Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Nov 11, 2024

Display a different colors for field in chart

Hi,

 

we have to display different colors for current temp in chart below based on user mode selected where iscurrent column is 1.

For example, Below visual shows data where deviceid selected is B0965C2B9CF2A6C855A3C245F6B72F1A:

The color of the current temp should vary according to the user mode where iscurrent is 1. Therefore in this case, usermode is auto

So color should be grey. if it is heat then red & if its cool then blue.
Below measure i created, but i am confused how to apply them for above visual when updatedon date column is in x-axis.

Dax:

Column Color =
VAR _UserMode = SELECTEDVALUE('HeatSense_Device'[UserMode])
RETURN
SWITCH( TRUE(), _UserMode = "cool", "#12239E", _UserMode = "heat", "#FF8C00", _UserMode = "fan", "green", "#808080" )

Please advise!

PFA file here https://1drv.ms/u/c/cfada767f73d87ed/ETnT9Q0ea9lCoVrDp0UpsDUBzoEt_xuy0cJ3EAEo8DBYgA?e=LTW4aI

Thanks in advance!

SergeiBaklan 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    If I'm not wrong conditional formatting is not applicable to shade area. Perhaps workarounds exist, but I don't know such.