In this Tiny Tip, Belinda will uncover the secrets on getting only the (sub)totals that you want to see, using the Microsoft Power BI Matrix visual.
The most important thing to note is that the Grand Total is a Sub-total. This means if you turn off the Sub-Totals, the grand totals disappear as well.
The Grand Totals will only always stay visible on the visual if you have the Stepped layout on; but if you turn the Stepped layout off, you can alter the labels for the totals.
2 thoughts on “Matrix (visual) totals and subtotals in Microsoft Power BI”
Pingback: Matrix (visual) totals and subtotals in Microsoft Power BI - 365 Community
On my visual I need to remove the Grand Total from the visual but cannot find a way to do it. Any assistance is greatly appreciated.