Forum Discussion
Matrix row subtotals not working
Hi 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.
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-sgandrathi1 year ago
Community Support
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.
- emmelielilja1 year agoRegular Visitor
Hi,
It hasn't been resolved I'm afraid, but I appreciate your help.- v-sgandrathi1 year ago
Community Support
Hi emmelielilja ,
We really appreciate your efforts and for letting us know the update on the issue.
I’ll explore any possible workarounds and share them if I find a suitable solution.
In the meantime, please continue using the Fabric Community Forum for further assistance.Thank you!