Wanted to use calculated column in measure

[sbm_tekade]

Hi Everyone,

I have one set of data where I calculated columns on certain conditions to apply conditional formatting on a visual-like matrix.

the conditional column having only two records in it i.e. TRUE and FALSE.

I wanted to use that column to apply conditional formatting on top of the visual using this column context by using measure StatusColor = SWITCH('Table'[Status], "TRUE", "blue", "FALSE", "red")

But the issue I was facing we are not allowed to use the calculated column in the above context to create new measures.

Can anyone suggest me different scenario or way to overcome this type of issue?

@Daryl-Lynch-Bzy

[LQuedas · Accepted solution]

ey @sbm_tekade ,

instead you create the new conditional column with TRUE and FALSE, why don't you use the name of the color and then use the option "Format Style" equal to "Field Value", e.g.

let me know if this help you...

Cheers, LQ