Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Please help!
I successfully used the following measure for backgorund conditional formatting:
It works fine, no problem.
On another tab I have a nearly identical viasual, using nearly identical Excel file. So I set up another measure:
Solved! Go to Solution.
@Anonymous
1. this is how i created measure in this case
3. below is the output
I am also attaching pbix file for your. there are two measure in the file for background color based on condition.
let me know if it helps you. thanks
Proud to be a Super User!
@Anonymous there is another way of creating measures.If possible, please try below option instead of hard coding the color, use 1,2, 3 . Then instad of field value use rules in your conditional formatting. Please refer to below screenshot. This will also give you more control on the color scale you wish to use.
Color Measure = Switch(true(), MAX('WTCV'[OBL %]) >=.98 , 1,
MAX('WTCV'[OBL %]) >=.92 , 2,
MAX('WTCV'[OBL %]) >=0 , 3
)
Do let me know if you still face any issue.
Proud to be a Super User!
@negi007 Thank you! This sounds like a great method, however, I am not sure how you are using the measure in this case.
@Anonymous
1. this is how i created measure in this case
3. below is the output
I am also attaching pbix file for your. there are two measure in the file for background color based on condition.
let me know if it helps you. thanks
Proud to be a Super User!
Hi @Anonymous ,
About share pbix file ,you could read the following article:
https://community.powerbi.com/t5/Desktop/How-to-upload-PBI-in-Community/m-p/1672886
Best Regards
Lucien
Hi @Anonymous ,
Could you pls share your pbix file? Remember to remove condient data.
Best Regards
Lucien
@Anonymous , Yiu can face issues when you do have text type of measure. Just try to type Obs in search and then try to select.
or
Can you share a sample pbix after removing sensitive data.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |