topic Re: Conditional formatting for a text based field using Measure in DAX Commands and Tips

Conditional formatting for a text based field using Measure

SK78 — Sun, 09 Aug 2020 14:34:23 GMT

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

Re: Conditional formatting for a text based field using Measure

lbendlin — Sun, 09 Aug 2020 18:04:23 GMT

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.

Re: Conditional formatting for a text based field using Measure

SK78 — Mon, 10 Aug 2020 00:06:06 GMT

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.

Re: Conditional formatting for a text based field using Measure

lbendlin — Mon, 10 Aug 2020 00:09:25 GMT

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