Forum Discussion

Shawry's avatar
Shawry
Icon for Helper I rankHelper I
2 years ago
Solved

Order dates chronoligically by month

Hi,    I'm facing an issue in the new year, where Jan 2024 is displaying prior to my 2023 months, when looking at the past 6 months worth of data. See below:      The data is coming from t...
Need Help
  • Shawry's avatar
    Shawry
    2 years ago

    Thanks, I managed to sort it by created a new column which concatenated Month + Year, rather than using MonthName by itself. Cheers 🙂 

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Shawry 
About the first part of the question, according to the picture you have a descending sort order just try to change it to ascending :

About the index problems you can't sort month - year by month order because both January has 1 as an index but 
January 2020
and January 2021 is not the same chronologically.
please refer to my answer from the linked discussion for more details (include the pbix  with example)

https://community.fabric.microsoft.com/t5/Desktop/sort-by-month-and-year/m-p/3620056#M1187145

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Shawry's avatar
    Shawry
    Icon for Helper I rankHelper I
    2 years ago

    Hi Ritaf1983 

     

    Thanks for your reply. 

     

    I have an Ascending sort order, based on Month Name. The 2023 months are dispalying fine, but Jan 2024 is not. I believe it has something to do with my Date table's Month Name column, being ordered based on the Month Number i.e. Jan = 1. 

     

     

    Thanks. 

      • Shawry's avatar
        Shawry
        Icon for Helper I rankHelper I
        2 years ago

        Thanks, I managed to sort it by created a new column which concatenated Month + Year, rather than using MonthName by itself. Cheers 🙂