Forum Discussion

GGR's avatar
GGR
Regular Visitor
11 years ago
Solved

SLICERS -> blank value

I have a question about using slicers in my report. I make slicer which show the two years, I have just two values in my year table. But I also see blank value , is it possible to hide this one ?  ...
Need Help
  • Anonymous's avatar
    Anonymous
    11 years ago

    adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.

Anonymous's avatar
Anonymous
Not applicable
11 years ago

adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.

adamgor's avatar
adamgor
Icon for Microsoft Employee rankMicrosoft Employee
11 years ago

Anonymous  Thanks!  I was able to apply a blanket page wide filter such as this, and it has fixed my issue!

 

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Unfortunately I use the same workaround.....

     

    They just need to add the option to be able to Turn Blank Values Off / On in the Slicer Options and I really hope they do this!