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.

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

      • juanita530's avatar
        juanita530
        New Member
        9 years ago

        I was able to remove blank as a choice in slicer by adding a report level filter. You have to make sure that blanks are not needed.