Forum Discussion
PaulKraemer
Advocate II
Advocate IISlicer 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...
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" )
danextian
Super User
Super UserHi 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" )