cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnThomas Helper I
Helper I

Re: Remove totals in matrix table

So where's the Matrix Properties?!!!  

codyj710
Frequent Visitor

Re: Remove totals in matrix table

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

Highlighted
Frankcf
Frequent Visitor

Re: Remove totals in matrix table

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

sriharsha36
Frequent Visitor

Re: Remove totals in matrix table

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
Frequent Visitor

Re: Remove totals in matrix table

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

sriharsha36
Frequent Visitor

Re: Remove totals in matrix table

sum1.JPG

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

manderee
New Member

Re: Remove totals in matrix table

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.

manderee
New Member

Re: Remove totals in matrix table

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.

daftraft
Regular Visitor

Re: Remove totals in matrix table

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

mhodges720
Frequent Visitor

Re: Remove totals in matrix table

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors