Remove totals in matrix table

[KimStenager]

How do I remove totals from the rows. When I make a matrix the columns delivers a total for every column, distubing the picture.

[CahabaData]

So I am going to add to this string because there is some confusion.  Yes the solution identified turns of ALL TOTALS.  But as per the original post - some of us want less sub-totals but still totals.  This question is not answered.

There is a post saying that one can right click and select Do Not Summarize - - but that post is incorrect as several have noted - it applies only to the Table visual, not the Matrix visual.

What is happening is that there is a Total line for each Row.  The Row fields are defined & showing in the Visual Design Pane at right.  To have a less number of Total lines you need to have a less number of Row fields.

In my case I had separate fields for customer name, customer number - - so I created a new calculated field that merged those 2 fields - -so then in the matrix I could have one less Row field - thus one less Total line....

hope this helps someone......

[strangerMike]

Thanks for your post CahabaData. It helped me.

[KarlinOz]

Yes this is crazy. I want to be able to show totals for the columns I choose, not all columns.

I only want to show a total for my $ amounts, the other 'totals' are nonsensical. The same behaviour as the Table visual would be good. And While I'm making suggestions, I'd really like to be able to edit those column headings - what is there is just silly!

[sriharsha36]

Go into the Fields Icon , which is on the Right End ( which is more of a Rectangle inside a Rectangle Shape). Right Click on the field which you do not want the total for "Check"/ "Select" the "Dont Summarize" option. 

[Noob78]

Hi! Could you please add a print screen, because I don't seem to find the elements... Thanks!

[sriharsha36]

Right Click on the field which you do not want to use the summarize option and tick mark the dont summarize option. 

[Anonymous]

This was it. Issue solved. Thank you!!

[manderee]

Thanks for the screenshots,  sriharsha36. Unfortuantely that only seems to work if the vizualization is a Table. When it is changed to Matrix, the option disappears.

[manderee]

Thanks for the screenshots, sriharsha36. Unfortunately that only appears to be an option if the visualization is a Table. When Matrix is selected, this option disappears.

[Frankcf]

I have checked my version of power bi desktop and do not seem to have the ability to turn off subtotals in a matix

[ronnoc]

This is a really hopeless thread. Obviously a few people including myself with no idea how to disable the row totals.

"Just go to matrix properties" is extremely vague as this ribbon or drop down either doesnt exist on the current version or is very well hidden.

[Tsanka]

Hi @ronnoc

Please take a look at the attached screenshot. Does it answer your question?

Best regards

Tsanka

[Anonymous]

Thanks!  I'm new to Power BI and could not find this.  Never thought to look under "General".  DOH!!  🙂

[daftraft]

This is the correct answer and should be promoted to the top. Thanks Tsanka!

[ronnoc]

Yes it does cheers! Missed it all along. Thank you

[codyj710]

Hi all,

Does anyone know if having sub-totalling as option at a field level is in the roadmap? 

I.e. right now, you either have an all or nothing when it comes to totalling a matrix with multiple row fields, some of which we don't need totalling on.

I don't think this is possibly currently?

Thanks in advance,

Cody

[tcrip]

THANK YOU.  Not only is it not called "Properties" it was not where I expected it to be.

[pbi2015]

Is there a way to remove totals from the rows but keeping the Grand Total?

[ash438]

Have you found any solution to this?

[CahabaData]

see my post of 4/20 on page 3 of this string

[Tsanka · Accepted solution]

According to me marix properties->General->Row Totals on/off should work