Conditional Formatting

[nataliesmiy1357]

Hello!  I am having trouble with my conditional formatting.  I have this one table, and wanting to make the columns all in the same color based on the level.

Attached is my photo for reference - I want the whole column to be a specific color based on the Level number.  If the level number is 4, I want the background color to be: #027108.  If the level number is 3, I want the background color to be: #1BCA50.  For 2: #A0D1FF, and for 1: #F7244E. Then for 0 - I want it to be the normal white.

Thanks in advance for your help!  I'm not sure how to do this!

[amitchandak]

@nataliesmiy1357 , Create a measure like this and use that in conditional formatting using field value option

Switch(Max(Table[Level Number]) ,
4,"#027108",
3, "#1BCA50",
2,"#A0D1FF",
1, "#F7244E",
"white"
)

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4