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 t...
Need Help
jakeryan56's avatar
jakeryan56
Advocate II
9 years ago

Oops, can you see it now?

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

      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

       

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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. :smileyhappy:

     

    Regards