Forum Discussion

PaulKraemer's avatar
PaulKraemer
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Slicer allowing Multiple Selections - selecting predefined items with one click?

Hi,   I have added a Slicer Visual to a report in Power BI Desktop that allows the selection of multiple items (Suppliers in this case).  There are 47 Suppliers as of today, but there is a group of...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    PaulKraemer you should add another column in your table to group these slicers and then in slicer add this group column on top of slicer column, selection this group will select all the suppliers under this group:

     

    Here is an example on adding a group column, you can always tweak the logic as you want.

     

    Supplier Group = 
IF ( Table[Supplier Name] IN { "Supplier 1", "Supplier 2 }, "Top Suppliers", "Other" )

     

PaulKraemer's avatar
PaulKraemer
Icon for Advocate II rankAdvocate II
1 year ago

Thank you jdbuchanan71 , parry2k , and danextian for your suggestions !

 

I ended up using parry2k's in this attempt, but I like danextian's idea of using a related table as it might make maintenance easier if the list of "Top Suppliers" needs to be added to or updated occasionally.  I'm going to play around with bookmarks also, and see what I can do accomplish with them.

 

I am a beginner, so I'm planning to try all options to get some experience.

 

I appreciate your help!

Paul