Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |