Forum Discussion
How to Limit Slicer Choices
I'm using multiple slicers when I'm generating a report, and I just ran into this issue. I want to compare two different locations, so I go to the location slicer and choose the two locations I am in...
Use a slicer to limit the choices of another slicer, then hide the first slicer.
It may be silly, but do work.
The problem is.... that one slicer wont limit the choices of another slicer. Thats the problem that needed to be solved?
The problem though is.... one slicer will not limit the selection of another slicer. Thats the fundamental problem that needs solving. Hiding it wont fix the fact that the remaining slicer still shows all the selection.