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,
Drag field from table below and add a measure to filter the data.
Table = ROW ( "Flag", "Yes" )
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?