how to show the more than two year of data as a separate lines in line chart

[snandy2011]

Hi all,

I just want to show more than 2 years as  separate lines in the line chart

I have calculated prior year count.When I select 2016, It is showing perfectly 2016 year count and prior year (2015) count.

Now, I selected 2015 and 2016 both,

Over here, I want to show prior year (2014) count as a separate lines instead of combine. That means 3 lines should be shown. Does anyone have any idea how to show that?

Could you please help me solve this? Thanks a lot in advance..

[Zubair_Muhammad · Accepted solution]

Hi @snandy2011

Try this.

Select the LINE CHART visual. Then Place the YEAR field in the "LEGEND"

[snandy2011]

Thank yoi very much @Zubair_Muhammad..

Your solution really works. Thanks once again.

Regards,

snandy2011