cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andymc123 Regular Visitor
Regular Visitor

Data Filter not in order of month number

I have looked at a few other posts trying to determine why my filter is not ordering by Month Number.  I have a column in the same table that contains month numbers, and I even tried adding a new table with only 2 columns, [months] and [month numbers], but the order of my filter list is still Alphabetical.  Could it be due to the fact that I have 2 years in the mix...2017 and 2018? I am simply trying to display the number of events in 2017 and compare with 2018.  Ideally there would also be a filter so that users can choose a month or group of months, and I guess I could it would just be better if that list of months was in month number order, not alphabetical order.  Ideas?  I have a snip below.

 

 MonthNumberNotSorting.png

1 ACCEPTED SOLUTION

Accepted Solutions
SonnyChilds Established Member
Established Member

Re: Data Filter not in order of month number

Try first selecting your "Month Name" column, then go to your modeling tab and sort by "Month Number". Your screenshot shows that Month Number is sorted by itself, but not that Month Name is sorted by the Month Number.

3 REPLIES 3
SonnyChilds Established Member
Established Member

Re: Data Filter not in order of month number

Try first selecting your "Month Name" column, then go to your modeling tab and sort by "Month Number". Your screenshot shows that Month Number is sorted by itself, but not that Month Name is sorted by the Month Number.

NickNg278 Senior Member
Senior Member

Re: Data Filter not in order of month number

@andymc123,

You can sort your month name by your month number, that way it will start from Jan

andymc123 Regular Visitor
Regular Visitor

Re: Data Filter not in order of month number

Thanks Sonny!  I feel stupid, and glad it was an easy fix Smiley Happy