Why is my columns on the chart does not follow the sequential of the month?

[LC]

Help please, I am very new on this program, I have uploaded the data the two years, and have set up the chart to show the data trend of these two years. I am not sure why the columns of the chart does not follow the month of the year in sequence, rather it follow the data value with higher in the front. For example, when I drill down the data, it show the Jan 2018, Jan 2017, Feb 2017 and then Feb 2018 instead of Jan 2018, Jan 2017, Feb 2018 and Feb 2017. The last two columns switch as the value in 2017 of Feb is higher than Feb 2018.

How can I change it to show by January 2018 vs Januay 2017 and Feb 2018 vs Feb 2017?

Thank you in advance

[v-yuezhe-msft · Accepted solution]

@LC,

Could you please share dummy data of your table so  that I can test? In addition, do you click the sort by data value option in the visual accidentally?



Regards,
Lydia