Forum Discussion

jakeryan56's avatar
jakeryan56
Icon for Advocate II rankAdvocate 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
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi jakeryan56

 

I don't thnk the screenshot worked, sorry.

  • jakeryan56's avatar
    jakeryan56
    Icon for Advocate II rankAdvocate II
    9 years ago

    Oops, can you see it now?

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft 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
        Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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