topic Color the Bar in bar chart as per previous bar value in App Development

Color the Bar in bar chart as per previous bar value

deeavhad — Sat, 19 Mar 2022 06:11:51 GMT

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

Re: Color the Bar in bar chart as per previous bar value

rubenmarin — Sat, 19 Mar 2022 10:29:14 GMT

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())"