cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
codyj710 Frequent Visitor
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

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

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

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

Re: Remove totals in matrix table

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

mhodges720 Frequent Visitor
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!!  :-)

Highlighted
CahabaData New Contributor
New Contributor

Re: Remove totals in matrix table

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......

www.CahabaData.com