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 🙂 

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

Hi,

In the Date Table, ensure that the month name column is sorted by the Month number column.  To your visual, drag Month name and Year from the Date table.

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

Hi Ashish_Mathur 

 

Thanks for your reply. 

 

I already have sorted the Month Name by Month Number, however, still experiencing the issue. January = 1, therefore, is displaying before following months. 

 

Month Name and Year are also the fields I'm using. 

 

 

So the issue seems to be that the Month Name is sorted by Month Number AND January = 1. Is there some sort of way to also sort by Year on top of this?

 

Cheers.