Forum Discussion

jakeryan56's avatar
jakeryan56
Advocate II
9 years ago

Date sort issue with visual

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?

Need Help

5 Replies

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago
        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?