Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |