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.

Djs231's avatar
Djs231
Regular Visitor
5 years ago

Simple and easy to overcome...and it is already built in...

Create a quick measure from the data entity measure used for your slicer/visual.

 

When creating the Quick measure select "different from the filtered value"

Then add your original entity measure as the default.

Then select the drop down -

options are:

"Show as Blank" 

Or

"Show as "0" in place of blank"

 

Select 

"Show "0" in place of Blank"

 

Now save the quick measure.

 

Go back to your slicer/visual and replace the selected entity measure with your newly created quick measure.... and Voila...No More (Blanks) on your visual/Slicer.