Forum Discussion
Dax color code for line graph
i have two lin values in Clustered column chart . i have attached two measure blow Glidepath OB21 = CALCULATE(SUM('Master Data Base'[Value Month]),'Master Data Base'[Reduction buckets]=" Glide...
Hi,
What kind of error are you getting? Anyway here is one way to do this:Color = SWITCH(TRUE(),[Base measure]>[Measure 2],"800000",[Base measure]>[Measure 1],"800000","Green")
End result:I hope this helps to solve your issue and if it does consider accepting this as a solution!
ValtteriN
Community Champion
Community ChampionHi,
What kind of error are you getting? Anyway here is one way to do this:
Color = SWITCH(TRUE(),[Base measure]>[Measure 2],"800000",[Base measure]>[Measure 1],"800000","Green")
End result:
End result:
I hope this helps to solve your issue and if it does consider accepting this as a solution!