Forum Discussion
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...
FGaspar - 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
c-es That's why it is often a good idea to + 0 to any calculation if you need to check something like that.