Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
4 years ago
Solved

Custom conditional formatting

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 the...
Need Help
Show and Tell
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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