Help with showing multiple years data on a month-day axis

[ericxu94]

Hi all, I have a data that contains multiple years, but I want them to be structured as one line a year (from pic1 to pic2), how can I do it?  Thanks in advance 

[v-lili6-msft · Accepted solution]

hi, @ericxu94 

For your case, just drag [Month] field into Axis and [Year] filed into Legend, Then it will work.

Result:

BeforeAfter

and here is sample pbix, please try it.

Best Regards,

Lin