Sort date on Line chart

[zpaul_010]

my data is composed of reports with create time and closed time ranging Dec 2017-July 2018 (this is just a sample data). 

When I plot them using Created date by Month, it shows this. 

This was sorted by monthnumber column (jan is 1, Feb is 2, etc. ).  As you can see, December was included where it should not because its dec 2017. If I add my older reports, im afraid that Nov 2017, Oct 2017 and so on will be ploted on the same line. 

I thought, numbering all months by number (jan 2015 as 1, Jan 2017 as 25) but I'd like to know if there's a better way. 

Any ideas?

[v-yulgu-msft]

Hi @zpaul_010,

Is it possible to add the "Year" onto X-axis together with "Month"? If not, I think the only way is to add an extra order column with numbers (jan 2015 as 1, Jan 2017 as 25). Then, change the default sort by option for Month column.

Regards,

Yuliana Gu