Forum Discussion
Matrix row subtotals not working
We’ve reviewed your requirement and created a sample report using dummy data based on the screenshot you shared. We were able to apply conditional formatting for the values, including background color using Data Bars (by unchecking “Show bar only”). This gives the effect you're looking for in the subtotal rows.
However, when it comes to category totals, Power BI currently doesn't provide an option to apply conditional formatting directly. We explored the available settings but couldn’t find a way to apply the same formatting to category totals. We’ve attached a screenshot for your reference, along with the PBIX file we used.
If you ever need a more customized or exact output in the future, we recommend reaching out to the Microsoft Partners team https://www.microsoft.com/en-us/power-platform/products/power-bi/partners# for further support. You can find more information and contact them through the link below.
Thanks.
I am facing the same issue.
The option in the subtotal "Apply to Labels" works differently for the "older" matrix and "newer" matrix.
In my investigation, my exisiting reports that were created with an older version of PBI on PBI Serivce still works the same as before. i.e. Selecting a background colour and apply to label only affect that single subtotal row while the new matrix will colour the entire row header as that colour. This only happens for "outline" and "tabular" layout.