Colour coding using conditional format -using measure not working

[anjuunni_06]

Hi,

I wrote a measure for colour formatting using conditional formatting for the subtitle of a slicer. The measure is given: 

Colour Format Rev Trend =

VAR Var_1=[Variance-RM]

VAR Result=

SWITCH(TRUE(),

Var_1 > 0, "#145a5a",

Var_1 = 0, "#999999",

Var_1 <0, "#C73D40")

Return

Result

It is showing the colour name  #145a5a instead of showing green colour. 

Please help.

Thank You

[Idrissshatila]

Hello @anjuunni_06 ,

I tried it and the measure is working normally as in the screenshot.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin