Data Filter not in order of month number

[andymc123]

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.

 

[Anonymous]

@andymc123,

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

[Anonymous · Accepted solution]

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.

[OParada1120]

Believe it or not...as old as this post is...this helped me in figuring out to how sort by the Month Number.

A very late, late thank you!

[andymc123]

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