Using conditional format to color the column

[biswad]

Hi, 

I'm trying to use conditional format to color the "Indicator" column on my dashboard. Basically, I have Branch and Role data If a Branch "London" Contains all three roles that are "Treasurer", "Secretary" and "President" it should be in "Green"

If Branch "Brighton" contains only two of the main role then it should be "Yellow" and If Branch contains only one of the 3 key roles it should be red, for example, branch "Kent".  Could anyone help me with how can I achieve this in Power BI, please?

[ibarrau · Accepted solution]

Hi. If you already have the column indicator you can just use it. If you want to build it, you can create a measure like this in order to use it as format condition of a Cell element:

Be sure to use Hexadecimal instead of words to show a nicer color than the regular one that PowerBi will render with the literal text.

I hope that helps,

[biswad]

Thank you so much brother, it was really very helpful. Much appriciated your help. Learned alot from this example.