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.

EZgrafton's avatar
EZgrafton
Icon for Advocate II rankAdvocate II
9 years ago

I found a quick trick. If applicable, add the field showing the blanks int he Page level filters section; on the filter check Select All then uncheck (Blank).

 

I hope this helps! :)

vshruti06's avatar
vshruti06
Icon for Advocate IV rankAdvocate IV
9 years ago

If we add the page level filter then it would be visible to end user after deploying it on powerbi.com. So I don't think this is a good idea.