Forum Discussion

lrockwell's avatar
lrockwell
Frequent Visitor
9 years ago
Solved

Months not in order

I have files from Salesforce, one being Action where there is a Completed Date that the Action has been done,  as well as the same in a file Activity with a Completed Date column as well. When i Char...
Need Help
  • lrockwell's avatar
    lrockwell
    9 years ago

    I discovered that if you sort on the visual it will categorize correctly. Redoing the visual in the most current version did not fix the issue. But this sorting method seems to be providing the correct output so I will run with that. 

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi lrockwell,

 

Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.

Best Regards!
Dale

lrockwell's avatar
lrockwell
Frequent Visitor
9 years ago

I have the latest version of Power BI installed. 

 

This is the error i am getting when i create a new column and sort the Completed Date on that 

 

  • kcantor's avatar
    kcantor
    Icon for Community Champion rankCommunity Champion
    9 years ago

    lrockwell

    Maybe go into query editor and add a date colum using the month number instead of name. then sort the month by the month number.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi lrockwell,

     

    1. According to my test, the months are in order when drilling down in an intelligent way. Maybe your current visuals were created in the old version. Please try to create a new one. If it works, maybe recreating all the visual would be an easy way.

    2. As kcantor suggested, sort the date column first, then add an index. Finally, we can sort the column by index.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

      

    Best Regards!

    Dale

    • lrockwell's avatar
      lrockwell
      Frequent Visitor
      9 years ago

      I discovered that if you sort on the visual it will categorize correctly. Redoing the visual in the most current version did not fix the issue. But this sorting method seems to be providing the correct output so I will run with that. 

       

      • GuySev's avatar
        GuySev
        Icon for Advocate I rankAdvocate I
        8 years ago

        lrockwell, Worked for me as well, thanx!