Hi,
I am using conditional formatting in Matrix, but could not get it in the totals.
Is there any way to do it ?
Many thanks.
Hey @Saniat ,
Not sure, but maybe the image below shows what you are looking for:
The above example is formatting the background color using the Field values formatting option, nevertheless, the Applies to property is available for all options though: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Hopefully, this provides what you are looking for.
Regards,
Tom
In addition to @TomMartens suggestion, it came to mind Parker Stevens posted this in 2020
which I keep bookmarked to share when these questions come up.
Dynamic Conditional Formatting for Values and Totals in a Power BI Matrix
Hey @Saniat ,
Not sure, but maybe the image below shows what you are looking for:
The above example is formatting the background color using the Field values formatting option, nevertheless, the Applies to property is available for all options though: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Hopefully, this provides what you are looking for.
Regards,
Tom
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
