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 shoudn't be visible. If all months don't have values, the year shouldn't be visible:
I read another similar posts, but didn't found any solution.
Best regards,
Filipe Gaspar
FGaspar - Yes, you can do this like:
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc=0,BLANK(),__Calc)
6 Replies
- amitchandak
Super User
FGaspar , Try to modify measure like
new measure = if([measure]=0, blank(), [measure]) // your orginal measure
and try
- Greg_Deckler
Community Champion
FGaspar - You cannot in your case because you have some 0's in those columns.
FGasparHi 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
FGaspar - Yes, you can do this like:
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc=0,BLANK(),__Calc)
