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.

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

I have tried this work around and can not get it to work. I am using thetable visual and in the Visual Filter and turning off do not display balnk. Can you please give me some more details about how you are doing this work around. Thank you.

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.

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

    • dcresp's avatar
      dcresp
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      This is a dashboard for external users so I am trying to avoid any page or report level filters, so agree not a great solution.

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

        I guess I was only "tricking" myself :mansad: