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.

intrasight's avatar
intrasight
Icon for Helper IV rankHelper IV
10 years ago

I also have "(Blank)" showing up. But there are no records with blank so the "filter" workaround isn't working.  So I'll ask again - why is there a "(Blank)" in the slicer?

TimothyS's avatar
TimothyS
New Member
10 years ago

Even though "Blank" is not showing up on other visualizations, uncheck "Select All" and select only the items you want. This will fix your problem. 

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

    It does not! (Blank) still appears. :mansad: