Forum Discussion
Conditional formatting for a text based field using Measure
Check your data strings for leading or trailing spaces or other fancy invisible characters that might return a negative comparison result.
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.
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.
Check your data strings for leading or trailing spaces or other fancy invisible characters that might return a negative comparison result.