Trouble displaying data in correct order by quarter/month

[ledoyle1121]

Hi,

I am using a line and stacked column chart to display the total number of requests received each month. I've been using the Timeline splicer to toggle between Year, Quarter, Month, etc. and it's been working well. However, for some reason when I've selected Q4 of 2017 and Q1 of 2018, the columns in the chart have not been displaying in the order I expect. For example, if I select Q4 and Q1, I would think the bars displayed would order the months as October, November, December, January, February, (and March if applicable). Instead, what I'm seeing is January, February, October, November, December. I'm trying to figure out how to manipulate my data to show the months not in the normal chronological order, but instead corresponding to the Quarters I've selected. 

I've attached a screenshot in hopes that someone might have a way to fix this. 

Thanks!

[v-yuezhe-msft · Accepted solution]

@ledoyle1121,

Please click the third drill down button to drill down your chart, and you can turn off concatenate labels for X-Axis.




Regards,
Lydia