Forum Discussion
Select All in Slicer (selecting hidden values)
I told it not to. In practice, this is 3 slicers. I just made 3rd one a table to make the explanation easier on people. In practice, Slicer A selects the target store chain, Slicer B Selects the Zip codes that chain is in (filtered from A), and Slicer C lets you select (after sorting by # of stores) competitive chains in the Zip Codes from B.
Try disabling that restriction and see what happens
- traviscole5 years agoAdvocate I
Defeats the purpose of the slicers. Slicer A is for when I want to show data for target stores. Slicer B is to just show stores in the zip codes. And Slicer C (table) is to pick out the top competitors in those zip codes.
Slicers are what they need to be, just need to know if anyone has a way to make the select all not select hidden things, or a trick to select 100+ boxes faster.