Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello! I am trying to make my columns color coordinated.... and I just can't make it work. I have the course name, and then I brought in the score but made it show the average. I want to color them if:
- the number is between 0 - 1 = no color
- between 1 -2 = #F7244E
- between 2-3 = #A0D1FF
- betweeen 3 - 4 = #1BCA50#
- anything 4 and above = #027108
How do I do this? Attached is a screenshot of my report. I want both columns with the background color of the colors above. Thanks in advance!
Solved! Go to Solution.
@nataliesmiy1357 , Hope you have a measure Avg of Score
Then create a color measure and use that in conditional formatting using field value option
Switch( True() ,
[Avg of score] <= 1, "#FFFFFF00",
[Avg of score] <= 2, "#F7244E",
[Avg of score] <= 3, "#A0D1FF",
[Avg of score] <= 4, "#1BCA50",
"#027108")
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
@nataliesmiy1357 , Hope you have a measure Avg of Score
Then create a color measure and use that in conditional formatting using field value option
Switch( True() ,
[Avg of score] <= 1, "#FFFFFF00",
[Avg of score] <= 2, "#F7244E",
[Avg of score] <= 3, "#A0D1FF",
[Avg of score] <= 4, "#1BCA50",
"#027108")
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |