Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hello,
Is there any way to switch off Grand Totals but show Sub Totals in a Matrix?
Thanks
Pete
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!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!