Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 44 | |
| 41 | |
| 36 | |
| 21 |
| User | Count |
|---|---|
| 176 | |
| 120 | |
| 106 | |
| 77 | |
| 52 |