Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Matrix Table How To Get Only One Sum #help

Hi

I want to create a matrix table that looks like the one below, with only one grand total for the entire row.

Yushiyima_3-1702629495440.png

 


But I couldn't achieve the desired appearance for my matrix table. How can I change it to have only one grand total?

Yushiyima_4-1702629534851.png

Settings

If I turn off subtotals, the grand total doesn't sum up

Yushiyima_5-1702629624975.png

 

 

 




1 ACCEPTED SOLUTION
zenisekd
Super User
Super User

@Anonymous here is your answer. You can set for columns whether they should subtotal. 

zenisekd_0-1702633312017.pngzenisekd_1-1702633374842.png

Kudos and mark as solution of this post appreciated 🙂

View solution in original post

3 REPLIES 3
zenisekd
Super User
Super User

@Anonymous here is your answer. You can set for columns whether they should subtotal. 

zenisekd_0-1702633312017.pngzenisekd_1-1702633374842.png

Kudos and mark as solution of this post appreciated 🙂

zenisekd
Super User
Super User

@Anonymous 
There must be something wrong with the fields that you are using in the visual.
This i how matrix looks like by default:

zenisekd_2-1702631672041.png

 

Anonymous
Not applicable

I'm using multiple columns for aesthetic reasons. However, when I use only one column, it works fine

Yushiyima_0-1702631862823.png

If I only use one column, it's working okay.

Yushiyima_1-1702631932183.png

 



 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.