Forum Discussion
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 ? ...
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
Advocate IV
Advocate IVThis 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
Advocate II
Advocate III guess I was only "tricking" myself :mansad:
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.