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

[FGaspar]

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

[amitchandak]

@FGaspar , Try to modify measure like

new measure = if([measure]=0, blank(), [measure]) // your orginal measure

 and try

[Greg_Deckler]

@FGaspar - You cannot in your case because you have some 0's in those columns.

[FGaspar]

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 · Accepted solution]

@FGaspar - Yes, you can do this like:

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(__Calc=0,BLANK(),__Calc)

[c-es]

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.