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 - September 2025
Check out the September 2025 Power BI update to learn about new features.
