Forum Discussion
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 eight suppliers of interest that will be selected 95% of the time. Is there a way that I can implement a way for users of my report to select this "group of eight" with one click rather than having to click each of these suppliers separately?
Any suggestions will be greatly appreciated.
Thanks in advance,
Paul
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" )
5 Replies
You could setup a bookmark that has the 8 selected and put a button on the page to trigger the bookmark.
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 , the solution from parry2k is the better way to go. It is easier to maintain (bookmarks can be finicky) and would be usable across all your reporting since it is on the table.
Hi PaulKraemer
Ensure to maintain a table of common selected suppliers in a table. Relate that to your actual suppliers table and create a calculated conditional column.
Supplier Category = IF ( NOT ( ISBLANK ( RELATED ( TopSuppliers[Supplier Name] ) ) ), "Group of 8", "Other Suppliers" )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
