Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
56 | |
38 | |
35 |
User | Count |
---|---|
85 | |
66 | |
59 | |
46 | |
45 |