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

Matrix totals without row sub totals

Hi, 

I have a matrix in Power BI. 2 fields in row, 1 in Column and 1 Value.

 

What I'd like is to show the grand total of the row, but not have a sub total for each row. I have tried so many things and looked on so many threads, but still can't get it to work. 

 

I have expanded the row so I can have the values side by side. 

 

Any idea how to get this information please?

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @EML_7 ,

 

On the matrix options you can setup the rows subtotals individually or turn of all of them:

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



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @EML_7 ,

 

On the matrix options you can setup the rows subtotals individually or turn of all of them:

MFelix_0-1664365368847.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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.