Matrix undefined

[Anonymous]

Hi Team,

I used matrix visual where i amusing 3 fileds called UNITS,RATIO PERCENTAGE,ERROR DIFF automatically  taking Sum.  how to avoid auto summarization in Matrix and I want to show zero in blank rows .please find the snippet for reference. 

Thanks in advance

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

It’s my pleasure to answer for you.

According to your description,I think replace blank value to zreo in PQ first.You can disable total in matrix format.

Like this:

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

The auto summarization is defined at the column level you need to select the column you need and set the summarization to Don't summarize, this however will be applied to all visualizations.

Just for a particular visualization you need to go column by column and set the summarization to Don't summarize on the options of each column:

Regarding the second part of your question to avoid blanks you need to have a measure to have that 0 inforced.

For that you need to have add a +0 or a IF statement. Don't know how your data is set but you can do a SUM, AVERAGE, MAX or MIN to return the values and then add a +0.

[Anonymous]

Hi 

Please can you tell me how to disable  don't summarization for matrix visual.

[MFelix]

Hi @Anonymous ,

You need to go to the matrix option and for each column that you place on the matrix and select the option don't summarize: