Hi @webportal ,
The accurate total from the underlying data, and a simple addition of the visible values, do not equate. This is a common pattern when the value you’re summing is on the ‘one’ side of a one-to-many relationship.
When you look at totals and subtotals, remember that those values are based on the underlying data. They aren't solely based on the visible values.
You can turn subtotals on or off in matrix visuals, for both rows and columns. When you turn on Subtotals and add a label, Power BI also adds a row, and the same label, for the grand total value. To format your grand total, select the format option for Grand total.
When you add a Matrix visual, it defaults to a stepped value, putting the subtotals next to the first row,
If you prefer the totals at the bottom, select the formatting pane for the visual, scroll down to the Subtotals section, and looks for “Row subtotal position” and change it to “bottom.”
If you don’t like the stepped format where the months are indented a bit, you can turn your matrix into more of a table format turning Stepped Layout off. Go to the Rows Headers section, and turn Stepped Layout off. Note that when you do this, it will automatically change the Subtotals/Row subtotal position setting to Bottom. You can change it back to top if desired.
For more information,you can refer to:
Subtotals and grand totals with matrix visuals
Making Sense Of Subtotals Settings In The Power BI Matrix Visual
7 Secrets of the Matrix Visual
Controlling Calculations and Labels on Subtotals
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @webportal ,
The accurate total from the underlying data, and a simple addition of the visible values, do not equate. This is a common pattern when the value you’re summing is on the ‘one’ side of a one-to-many relationship.
When you look at totals and subtotals, remember that those values are based on the underlying data. They aren't solely based on the visible values.
You can turn subtotals on or off in matrix visuals, for both rows and columns. When you turn on Subtotals and add a label, Power BI also adds a row, and the same label, for the grand total value. To format your grand total, select the format option for Grand total.
When you add a Matrix visual, it defaults to a stepped value, putting the subtotals next to the first row,
If you prefer the totals at the bottom, select the formatting pane for the visual, scroll down to the Subtotals section, and looks for “Row subtotal position” and change it to “bottom.”
If you don’t like the stepped format where the months are indented a bit, you can turn your matrix into more of a table format turning Stepped Layout off. Go to the Rows Headers section, and turn Stepped Layout off. Note that when you do this, it will automatically change the Subtotals/Row subtotal position setting to Bottom. You can change it back to top if desired.
For more information,you can refer to:
Subtotals and grand totals with matrix visuals
Making Sense Of Subtotals Settings In The Power BI Matrix Visual
7 Secrets of the Matrix Visual
Controlling Calculations and Labels on Subtotals
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
