cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chandramohanry
Frequent Visitor

Matrix undefined

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. 

 

chandramohanry_1-1606300252416.png

Thanks in advance

 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @chandramohanry 

 

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:

2.png3.png

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.

View solution in original post

4 REPLIES 4
v-janeyg-msft
Community Support
Community Support

Hi, @chandramohanry 

 

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:

2.png3.png

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.

View solution in original post

MFelix
Super User III
Super User III

Hi @chandramohanry ,

 

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.

 

MFelix_0-1606301670193.png

 

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:

MFelix_1-1606301815527.png

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi 

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

Hi @chandramohanry ,

 

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:

MFelix_1-1606301815527.png


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.