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.

ignas's avatar
ignas
Icon for Advocate II rankAdvocate II
8 years ago

Hey guys :)

 

I am not sure if anybody did not have the solution earlier but I did this:

  • Create 2 filters
  • First filter filters second filter, but nothing else in the page. Then I hide this filter somewhere in a corner with changing colors.
  • Then second filter does not have anymore options that are not selected by the first filter.

 

Regards,

 

Ignas

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you very much, that was the solution for me.