Changing the color of data points on a line chart for the current year

[Anonymous]

Hi All,

I have a requirement where I need to change the color of the data points on line chart only for the current year. The line chart is showing values for 5 Years. Can someone help me on this. Thanks in advance.

Regards,

Ankita Arvind

[bhavyagrb]

Hi Ankita,

With the help of my sample dataset, I tried to change color of current year datapoints in linechart by choosing the custom option in Colors & Legend panel and giving expression:

if(sum({<Year={$(=max(Year))}>}Sales),yellow(),red()).

Pls have a look in the below attached image.

Regards,

Bhavya

 

[Kushal_Chawda]

Do you have a single dimension in line chart or two?