How to apply background colour to specific rows and cells in Power BI Desktop

[smjzahid]

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

[Fowmy · Accepted solution]

@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...