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
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

Drag field from table below and add a measure to filter the data.

Table =
ROW ( "Flag", "Yes" )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
    Anonymous
    Not applicable
    8 years ago

    I have been describing this issue poorly, I really only need a visual level filter for a slicer... which does not seem to be possible. 

    • ajohn1's avatar
      ajohn1
      Advocate I
      7 years ago

      I know exactly what you are trying to do as I'm trying accomplish this myself. Right now I have buttons that that overlap one another and it works. One button sets the filter to 'Y' and the other sets the filter to "All Data". As one button is press, it hides itself and shows the other button. It works but it is not flawless as I would like it to be when using it online. Hope this helps.