unable to add conditional formatting on a measure which returns text output

[utkarshshastri]

pbi

the above account stage column is a measure and I am trying to add consitional formatting using measure , and New color code is created suing below DAX query 

New color code =

VAR colorcode =SELECTEDVALUE('color code'[Account stage])

RETURN

SWITCH(TRUE(),

colorcode ="High Awareness",1,

colorcode ="Medium Awareness",2,

colorcode ="Low Awareness",3,

colorcode ="High conversion",4,

colorcode ="Medium conversion",5,

colorcode ="Low conversion",6,

colorcode ="High Engagement",7,

colorcode ="Medium Engagement",8,

colorcode ="Low Engagement",9

)

I am not sure what is wrong I am not able to get values in column or able to conditonally format the account stage column

thanks in advance 

[utkarshshastri]

thanks @MFelix  it worked like a charm

[MFelix · Accepted solution]

Hi @utkarshshastri ,

If the value you are using for the condittional formatting is a measure you must use the measure itself and not the SELECTEDVALUE try the following:

New color code =
SWITCH([Account stage],
"High Awareness",1,
"Medium Awareness",2,
"Low Awareness",3,
"High conversion",4,
"Medium conversion",5,
"Low conversion",6,
"High Engagement",7,
"Medium Engagement",8,
"Low Engagement",9
)