Conditional formatting on the basis of more than 1 column

[Rana_Rumeel]

I need to apply Custom Font color formatting on the bases of these 2 columns.

If the value in Col 1 is between -10 and +10
If value in Col 2 is between -10 and +10
then Green Else Red

I tried following Switch condition but it is not working
#418344 is green color and #DF595C is red.

SWITCH(

TRUE(),

Col 1 <=10, "#418344",

Col 1 >=-10, "#418344",

Col 2 <=10, "#418344",

COl 2 >=-10, "#418344"

,"#DF595C"

)

[SpartaBI · Accepted solution]

@Rana_Rumeel 

SWITCH(

TRUE(),

Col 1 <=10 && Col 1 >=-10 && Col 2 <=10 && COl 2 >=-10, "#418344",

"#DF595C"

)

      

Showcase Report – Contoso By SpartaBI

[SpartaBI · Accepted solution]

@Rana_Rumeel 

SWITCH(

TRUE(),

Col 1 <=10 && Col 1 >=-10 && Col 2 <=10 && COl 2 >=-10, "#418344",

"#DF595C"

)

      

Showcase Report – Contoso By SpartaBI

[SpartaBI · Accepted solution]

@Rana_Rumeel my pleasure 🙂
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543