Forum Discussion

Anonymous

Not applicable

8 years ago

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...

Resident Rockstar

8 years ago

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:)

Anonymous
Not applicable
8 years ago
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?
Anonymous
Not applicable
7 years ago
SivaMani Anonymous v-chuncz-msft
my data is in cloud and it changes time to time so i don't know what item will be there on daily basis. What i want is to simple select all except the Blank(). Please see the image attached.

Any help is appriciated. Thank you guys
- SivaMani
  Resident Rockstar
  7 years ago
  Anonymous,
  
  Try the below approach
  
  The reason for blank values can be found here
  
  Thanks,
  Siva
  - Anonymous
    Not applicable
    7 years ago
    SivaMani Thank you for the reply. Will this work if my list grows from backend?