Forum Discussion
clear all slicer selection
Hi, Is there a way to clear all current selection (kind of go back to the default slicer setting when the report was loaded) with just one action ?
That's the say a slicer works from what I can see. A slicer filters based on what you've checked. If you don't check a box, there is no filter applied. The blank appears if you have possible blank choices--or if you have relationships that somehow results in a blank. I usually filter out the blanks on a page to prevent that...but remember if you do that, the ISFILTERED(for that column) will be true. To get around that create a "dummy" duplicate and prevent blanks on that one.
Thanks for the tips. Did you sense I was attempting answer the question: how to "clear all slicer selection"? By your response, I don't think I succeeded.