change color of max dimension in chart

[marjan_it]

Hi all

I have a filed that shows years and some chart that dimensions are year and expression is different.

I want to show the expression in last dimension in different color. how can i do that?

when dimension has the last year its ok like this

but when it has not its not work

I want that "1" in dimension 1392 would be chang

[arvind1494]

Off auto color

then choose color by expression

expression

if(year =1392,green(),red())

then your chart will show green color for year 1392 and remaining will be red.

[marjan_it]

I have a lot of chart like this with different dimension. I want something dynamic.

[arvind1494]

then

use

if(year =max(year),green(),red())

[marjan_it]

It does not work .

[YoussefBelloum]

what type of chart you're using and where did you put the coloring expression ?

[tresesco]

May using total like?

if(year =max(total year),green(),red())

[marjan_it]

No, with this all change all of the chart red.

[marjan_it]

Chart is line chart and I put put coloring expression in background color both in expression and dimension.

[tresesco]

Actually, red() and green() should swap:

if(year =max(total year), red(), green())