Color the Bar in bar chart as per previous bar value

[deeavhad]

For bar chart my x-axis has months and y axis has calculated value, so I want to color current month bar based on previous month bar value. e.g. for previous month bar value is 50 and for current month bar value is 45 then current month bar should be green

[rubenmarin · Accepted solution]

Hi, you can use Above() to retrive the presious bar value, so if you rexpression is "Sum(Amount)", the color expresion could be "If(Sum(Amount)<Above(Sum(Amount)), Green(), Red())"