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.

vshruti06's avatar
vshruti06
Icon for Advocate IV rankAdvocate IV
10 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
10 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
    10 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.