Forum Discussion
Removing Values from Slicers
Is there a way to hide the blank values but not filter out the data? For example: I have a column with binary values "Yes" or "No" but I want the slicer to just have the "yes" option showing...
Anonymous,
of course. There is a way to do this.
- Create another slicer with the same field
- Select values which you want to display. In your case, select yes
- Hide the slicer: Option available in Selection Pane
Let me if you need any other help:)
Hey SivaMani,
This filters out data that I need in my report though. All I want is a way to filter out slicer options without actually removing the data.
Just want to be able to hide a value in a slicer without actually filtering out the data. The Slicer currently shows "Yes" & "No" as selection options, I want it the slicer to just show "YES" because no one will ever be selecting "NO".
Can anyone advise?