Matrix Visual

[Anonymous]

Hi All,

I have a created a Matrix visual. But I would like to fill the empty spaces in the visual with 0.

Is it possible?

If so, can I please how to do that?

Any help is appreciated!

Thank you!

Megha

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

If you are putting measure in the value section of the matrix visual then you can put a if condition where calculation return value is blank then return 0 else it will return calculate value. Below is the pseudo code of it.

measure = 
var _calc = <your calculation>
return if(_calc = blank(),0,_calc)

or simply add +0 at the end like this:-

measure = <your calculation>+0

Thanks,

Samarth

[v-jingzhang · Accepted solution]

Hi @Anonymous 

I'd like to complement a point that if you are putting a column in the Values section, you can create a measure with corresponding aggregation type for the column, like

Total = SUM('table'[Column]) + 0 

Or 

Count = COUNT('table'[Column]) + 0

Or use other aggregation functions per your need. Use this measure in the matrix to replace original column field. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

I'd like to complement a point that if you are putting a column in the Values section, you can create a measure with corresponding aggregation type for the column, like

Total = SUM('table'[Column]) + 0 

Or 

Count = COUNT('table'[Column]) + 0

Or use other aggregation functions per your need. Use this measure in the matrix to replace original column field. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

If you are putting measure in the value section of the matrix visual then you can put a if condition where calculation return value is blank then return 0 else it will return calculate value. Below is the pseudo code of it.

measure = 
var _calc = <your calculation>
return if(_calc = blank(),0,_calc)

or simply add +0 at the end like this:-

measure = <your calculation>+0

Thanks,

Samarth

[Anonymous · Accepted solution]

Thanks so much! @Samarth_18