I have below table in excel which has been conditionally formatted for background colour (see snip below) for the highlighted colours (Green, Grey etc).
How do I achieve this in Power BI Desktop. The data in excel exist as it is shown in below snip,
Any hint or help is appreciated
@smjzahid
It is possible to apply background colors in a matrix visual based on a condition. The condition could be built using a measure and use it for formatting. Choose Background.
Create a measure that evaluate the condition to check then use RULE in the settings window as needed
Refer to this comprehensive article: https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-vis...
@smjzahid
It is possible to apply background colors in a matrix visual based on a condition. The condition could be built using a measure and use it for formatting. Choose Background.
Create a measure that evaluate the condition to check then use RULE in the settings window as needed
Refer to this comprehensive article: https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-vis...
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
