Forecast for current year

[Anonymous]

Hello everyone,

I want to show dotted line for current year in line chart.

i am not getting how to show expression for current year.

i used below exp but it show dotted line after current date but i want show for current year(not selected year)

=IF(date>Today(),'<s3>','<s1>')

Thanks.

[MK_QSL · Accepted solution]

IF(Year(OrderDate) = Year(Today()),'<s3>','<s1>')

Replace OrderDate with your Date Field

Make sure that you have to use this expression in Line Style

[Anonymous]

Perfect.. Thank you Manish