How to select Multiple options across multiple Slicers in Power BI?

0
votes

I would like to select "Desktop" from 1st slicer and and "Last Week" from 2nd slicer, but as it turns out, i can select only one option from one slicer at a time, i want to highlight only last week values for desktop category,

Note: i tried Hierarchy Slicer from Market, but if i select Desktop/Last week and Mobile/Last week both at a same time, the visual is not being displayed.

The following are the pictures of what i am trying to do here:

hierarchy slicer

Demo Data

Thank you in advance.

1
powerbipowerbi-desktop
A hierarchy doesn't really make sense. Why can't you use two separate slicers? – Alexis Olson
Exactly, i am trying to use 2 slicers which should be buttons and i want to choose multiple options, lets say, "desktop & mobile " and "Last Week" which i cant unless i use basic slicers where i can toggle multiple selections in format options. – Ahmed Abdul Salam
You can definitely make multiple selections on a single slicer and multiple selections across multiple slicers. If the custom slicer you're using doesn't work like that, try the ChicletSlicer from the store. It should be similar. – Alexis Olson
the ChicletSlicer works like charm!, Thank you @AlexisOlson – Ahmed Abdul Salam

1 Answers

0
votes

I would stick with the regular Slicer as far as possible.

You can make multiple selections by holding down the Ctrl key on your keyboard while clicking. You can also change the Format of the Slicer, under Select Controls turn Single select off. This gives a multi-select UI.