Forum Discussion
Individual colors for Data labels
Hi,
Request your guidance for giving individual colors to Data labels in a line chart visual.
The line chart visual is based on daily sales, if the sales for today is greater than yesterday then color of data label should be Green, if the sales is equal to previous days sale then color of Data label should be Amber and finally if sales is less than previous days sales then color of Data label should be red
kindly advise how can we make this happen
regards,
dsmitha
Anonymous , Put below measure in Format => Data Label => Values => fx
Measure =
var _CurDate = SELECTEDVALUE('Table'[Date])
var _CurVal = CALCULATE(COUNT('Table'[Sale]), 'Table'[Date]=_CurDate)
var _PrevDate = CALCULATE(PREVIOUSDAY('Table'[Date]), 'Table'[Date]=_CurDate)
var _PrevVal = CALCULATE(COUNT('Table'[Sale]), 'Table'[Date]=_PrevDate)
return
IF(_CurVal>_PrevVal, "#008000", IF(_CurVal<_PrevVal, "#FF0000", "#FFBF00"))
2 Replies
- ddpl
Solution Sage
Anonymous , Put below measure in Format => Data Label => Values => fx
Measure =
var _CurDate = SELECTEDVALUE('Table'[Date])
var _CurVal = CALCULATE(COUNT('Table'[Sale]), 'Table'[Date]=_CurDate)
var _PrevDate = CALCULATE(PREVIOUSDAY('Table'[Date]), 'Table'[Date]=_CurDate)
var _PrevVal = CALCULATE(COUNT('Table'[Sale]), 'Table'[Date]=_PrevDate)
return
IF(_CurVal>_PrevVal, "#008000", IF(_CurVal<_PrevVal, "#FF0000", "#FFBF00"))