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 is and another where the detail of those categories is. Where if I select a provider in the segmenter of the categories it should only show me the categories that refer to that provider and in turn the detail segmenter to its category. As I show below:

Adee_7_0-1643764740572.png

If I unfold each of them shows me their content, but not the segmentation that should exist in them. I have made a table that has the data to which each combination belongs; for example provider a corresponds to category 1 and detail b as shown in the table below

Adee_7_2-1643764985724.png

And I have also generated one of the relationships with which they must interact from the model...

Adee_7_3-1643765103017.png

But it still shows me the content of the entire catalog, so that when I deploy my provider it only shows me the categories it has access to and in turn the relationships with the details.

I will thank you infinitely if you support me in orienting me, what do I need to add or what else do I have to do so that my segmentation can work?

Best regards

<iframe title="testseg - Página 1" width="600" height="373.5" src="https://app.powerbi.com/view?r=eyJrIjoiNmM1Y2RjNWQtNmE1OS00NzBlLWIwMzctMDUwOGI4ZDUwNWNhIiwidCI6IjIzMmQ5YzU5LThkMmQtNDJjNC04NzM4LTA1NjE0YmE2NzFlOSJ9" frameborder="0" allowFullScreen="true"></iframe>

Since it does not allow me to upload the file, it occurred to me that maybe published can work

  • 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.

     

     

8 Replies

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      Hello, good day,

      I have generated a sample file, but it does not allow me to upload it, I do not understand why...

      Then I will share the tables

      Suppliers Catalogue
      Provider A
      Provider B
      Provider C

      Catalogue Categories
      Category 1
      Category 2
      Category 3
      Category 4
      Categoroa 5

      Details Catalog
      Detail to
      Detail b
      Detail c
      Detail d

      Table of Combinations

      Provider ACategory 1Detail to
      Provider ACategory 1Detail b
      Provider BCategory 2Detail to
      Provider BCategory 4Detail to
      Provider CCategory 3Detail c
      Provider CCategory 5Detail c
      Provider CCategory 5Detail d

      In advance I thank you

      Best regards

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      Hello!

      In these days I have tried to upload the file but this legend marks me

      Adee_7_0-1644283777891.png

      Can you tell me how else I might share the file I generated?

      I think with the example tables I went up it wasn't enough.

      I have not yet been able to solve this situation.

      I hope you can help me. Thank you

  • 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.