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

View all the Fabric Data Days sessions on demand. View schedule

Reply
Chalklands
Helper I
Helper I

Show subtotals but not Grand Totals

Hello,

Is there any way to switch off Grand Totals but show Sub Totals in a Matrix? 

 

Thanks

 

Pete

1 REPLY 1
Sean
Community Champion
Community Champion

No unfortunately this is not possible although it should be!

When you go to the Subtotal Options of the Matrix you can turn on and off both Row Subtotals and Column Subtotals

However this also affects the Grand Total Row and/or the Grand Total Column but it should NOT !

You should be able to turn on/off only the Grand Total Row/Column independent of the Row/Column Subtotals.

Vote for this Idea!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13185840-please-provide-a-way-to-...

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors