Forum Discussion
Matrix row subtotals not working
Hi!
I have tried what you said many times. It seems like the matrix is treating my row headers as values. I have attached an image of the row subtotals settings. All row levels, except Month and Close Probability are OFF (I have removed Account Names and Owner Names for security, but otherwise it would be ON on Account Name and Name).
Now, if I create a background color and apply this to labels, this happens.
These are the settings I have in my old version
And this is what happens:
Community SupportHi emmelielilja,
Thank you for sharing additional details and screenshots.Based on your follow-up, it seems that the behavior change is due to how Power BI's newer versions (March 2025 and later) handle matrix row headers and labels differently compared to older builds.
The matrix now treats certain row levels like values during formatting operations. This impacts both subtotal controls and label formatting.
To resolve this fully:
Ensure you have Stepped Layout turned ON in the matrix settings.
Double-check under Subtotals àPer Row Level and turn ON subtotals specifically for your key fields.
When applying background formatting, ensure you apply it to Rows and not to Values.
If needed, re-arrange fields order under Rows panel, sometimes moving them slightly resets the formatting logic.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
- v-sgandrathi
Hi emmelielilja,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
- v-sgandrathi
Hi emmelielilja ,
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Thank you.
Hi,
It hasn't been resolved I'm afraid, but I appreciate your help.