Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Multi-catalog slicer

Hello Community! I hope everything goes well, in my path of learning Power Bi, I have encountered a new challenge, I have 3 catalogs: one where my suppliers are, another where my service category...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Syndicate_Admin 

     

    You can try the following methods.

    Measure1 = 
Var N1=SELECTEDVALUE(Suppliers[Suppliers])
Return 
IF(SELECTEDVALUE(Combinations[Suppliers])=N1,1,0)

    Place Measure1 in the Catalogue view and set it equal to 1.

    Measure2 = 
Var N1=SELECTEDVALUE(Suppliers[Suppliers])
Var N2=SELECTEDVALUE(Catalogue[Catalogue])
Return 
IF(SELECTEDVALUE(Combinations[Suppliers])=N1&&SELECTEDVALUE(Combinations[Catalogue])=N2,1,0)

    Place Measure2 in the Details view and set it to equal 1.

    At this point, after one slicer option is completed, the second slicer option is changed accordingly. The options for the third slicer depend on the selection of the first two slicers.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, Syndicate_Admin 

 

I don't know if I understand it correctly. Are you trying to use the slicer function? As shown in the picture.

 

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hello!

Thank you very much, for answering me.

However it is not precisely what I need, look according to my table, when selecting provider B, in the segmentation of data I should only get the categories that correspond to him, in this case only Category 2 and Category 4, but the reality is that in the segmentation I deploy all the categories ...

Adee_7_0-1644339370531.png

Look at my chart...

Adee_7_1-1644339441272.png

And after selecting the right category, let's say category 2, in the data segmenter I should only see the detail a, but not all, as it is happening ... 😞

Adee_7_2-1644339585032.png

The correct selection should be so

Adee_7_3-1644341072585.png

Right now to explain, use filters, but it should be automatic according to my table of combinations...

Adee_7_4-1644341204514.png

How can I do it?

I thank you in advance

Best regards

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Syndicate_Admin 

     

    You can try the following methods.

    Measure1 = 
Var N1=SELECTEDVALUE(Suppliers[Suppliers])
Return 
IF(SELECTEDVALUE(Combinations[Suppliers])=N1,1,0)

    Place Measure1 in the Catalogue view and set it equal to 1.

    Measure2 = 
Var N1=SELECTEDVALUE(Suppliers[Suppliers])
Var N2=SELECTEDVALUE(Catalogue[Catalogue])
Return 
IF(SELECTEDVALUE(Combinations[Suppliers])=N1&&SELECTEDVALUE(Combinations[Catalogue])=N2,1,0)

    Place Measure2 in the Details view and set it to equal 1.

    At this point, after one slicer option is completed, the second slicer option is changed accordingly. The options for the third slicer depend on the selection of the first two slicers.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      Thanks a lot!

      👏👏 🎈🎈🎉🎉🤗

      I already implemented it, in truth, thank you very much

      Best regards

      • v-zhangti's avatar
        v-zhangti
        Community Support
        4 years ago

        Hi, Syndicate_Admin 

         

        If you have solved the problem, please consider Accept a correct reply as the solution to help others find it.

         

        Best Regards