Forum Discussion

Anonymous's avatar
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...
Need Help
Anonymous's avatar
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's avatar
SivaMani
Resident Rockstar
7 years ago

Anonymous,

 

Try the below approach

 

 

 

The reason for blank values can be found here

 

Thanks,

Siva

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    SivaMani Thank you for the reply. Will this work if my list grows from backend?

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      7 years ago

      Anonymous,

      Yes, It will work. It excludes only blank value.