Forum Discussion
FGaspar
Helper I
Helper IHow 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...
FGaspar - Yes, you can do this like:
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc=0,BLANK(),__Calc)
Greg_Deckler
Community Champion
Community ChampionFGaspar - Yes, you can do this like:
Measure =
VAR __Calc = <some calculation>
RETURN
IF(__Calc=0,BLANK(),__Calc)
Neither of the above proposed solutions above work if the values are null
- Greg_Deckler
c-es That's why it is often a good idea to + 0 to any calculation if you need to check something like that.