Forum Discussion
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!
1 Reply
- SergeiBaklanDiamond Contributor
If I'm not wrong conditional formatting is not applicable to shade area. Perhaps workarounds exist, but I don't know such.