Forum Discussion

FGaspar's avatar
FGaspar
Helper I
6 years ago
Solved

How to hide columns with empty values in a matrix visual.

Hi,   I'm trying to hide empty values in a matrix visual. In the example below I have two measures for each month/year. If both measures are empty in the same month (for all rows), that month shou...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    FGaspar - Yes, you can do this like:

     

    Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(__Calc=0,BLANK(),__Calc)
FGaspar's avatar
FGaspar
Helper I
6 years ago

Hi Greg_Deckler ,

 

Thanks for your reply.

 

Can I change the measure (I have a live connection to SSAS) to retrieve "blank" instead of "0"?

 

If so, can I hide the blank values?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

FGaspar - Yes, you can do this like:

 

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(__Calc=0,BLANK(),__Calc)
  • c-es's avatar
    c-es
    Regular Visitor
    3 years ago

    Neither of the above proposed solutions above work if the values are null

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      c-es That's why it is often a good idea to + 0 to any calculation if you need to check something like that.