Conditionnal formatting with 2 columns as a condition using SWITCH

[Mila]

Hi,

I've have to color a Speed column regarding to 2 others columns (Vari and Type).  When Vari >5 and Type in (10, 20) I should put Red color for Speed otherwise White.

I've created Colour mesure below :

Colour =

SWITCH(

TRUE(),

SELECTEDVALUE('Fact'[Vari] ) > 5 && SELECTEDVALUE('Fact'[Type]) =10 , "Red",

SELECTEDVALUE('Fact'[Vari%] ) > 5 && SELECTEDVALUE('Fact'[Type]) =20 , "Red",

"White")

But I'm not able to Use this calculated mesure in conditionnal formating as you can see in the picture (It's in French)

I need your help.

Thank you

[Seanan]

Hi @Mila

Is your measure set to the Text format?

[Mila]

Hi @Seanan ,

I don't have "Text" option in the Format box.

Do you have any idea of what is wrong whit my mesure Colour?

Thanks

[Seanan]

Hi @Mila 

Would you be able to provide the PBIX file without any sensitive data?

[Mila · Accepted solution]

Spee	Var	Typ
12	9	10
5	2	5
50	8	20
45	3	5
13	2	10