Date sort issue with visual

[jakeryan56]

I have data coming from two different sources (SalesDataFY17Q3 and SalesDataCurrent) into a combined query (SalesData). One of the sources is data from last quarter (October, November December) and the other is the current quarter (Jan, Feb, Mar).
I have created a visual for trends of measures over time. All the data displays correctly but when I "Sort by month" it doesn't sort them in the correct order as seen in the screenshot below.
Any ideas?

[Phil_Seamark]

Hi @jakeryan56

I don't thnk the screenshot worked, sorry.

[jakeryan56]

Oops, can you see it now?

[v-ljerr-msft]

Hi @jakeryan56,

Have you tried the solution provided above? Does it work in your scenario? If you still have any question, feel free to post it here.

Regards

[Phil_Seamark]

Hi

I suspect you need to add a year component. So change 'January' to 'January 17'. This includes the underlying column you may be using as a 'sort by column'.

Do you have a Calendar table in your model?

[Phil_Seamark]

If you leave the data grouped as 'January' then you risk having the following data all being grouped into one bucket which is probably not what you are after.

• January 2015
• January 2016
• January 2017