Forum Discussion
Visual level filtering for slicers
There is a hack for this ...
1. turn the visual into a bar chart
2. apply the visual level filter
3. turn the visual back into a slicer
Thanks @sumit4732 It's a great workaround! Just wanted to add that you can hide SL2 in the Selection Pane, it will eliminate the need for step 4 and 5.
I just saw another option for this that Mike_Carlo came up with. Since we can show and hide things on a page, he just copied a slicer, filtered it, then hid the slicer. The other slicer retains the same context without the filtered out value and no one is the wiser. A bit harder for someone else to discover :) but its super quick without the need to layer things. As a seperate note I just thought of, it would be easy to just create a bookmark page that contained the filtered slicers, would be easier to discover.
- Here is the tutorial on how to accomplish this: https://powerbi.tips/2018/05/apply-a-filter-to-a-slicer/
Hi Mike,
Isn't your solution the same as using a Page/Report level filter? If not, what's the difference?
Thanks
Robin
Anonymous The effect is the same, the difference is that the filters panel is available to the end user, and they can modify and remove those filters. This method effectively removes the capability of an end user to see or modify anything.
This 'solution' is great if you have only a few visualizations that need interactions to be turned off. It is much more cumbersome of a 'solution' when you have a page of over 30 stacked visualizations.
