Conditional formatting for a text based field using Measure

[SK78]

Referenced this youtube video: https://www.youtube.com/watch?v=Y8xmJgVjdZs

I created a measure in the measures table to perform conditional formatting on a field that has text values

In the conditional formatting for section

Can’t seem to find out why only conditional formatting is working for some fields that have the same Value: This is occuring for throughout the dashboard for even other values mentioned in the DAX measure

I am trying to decipher with no luck. Any pointers will be greatly appreciated

Thanks

SK78

[lbendlin]

You can specify colors directly and also simplify the Switch statement.

switch(ChaRMstatus,"Created","Green","In Development","#2F4F6F","white")

There are lookup tables available on the interwebs with the accepted colo(u)r names.

Then do the conditional formatting based on field value rather than rules.

Note: Not sure if naming a variable the same as the measure it is in is a good idea.

[SK78]

I tried the suggestion you shared but still running into error..

Any thoughts or pointer - can't seem to figure out why some entries of the same value get highlighted but others don't. 

[lbendlin · Accepted solution]

Check your data strings for leading or trailing spaces or other fancy invisible characters that might return a negative comparison result.