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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.