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