Forum Discussion
Sorting by Month name using month number doesnt work
Hello!
I need hel from you guys. I actually searched abput sort correctly by Month name, creating a Month nummber column and sort the column Month name by Month number, but didt work.

I have this date column, that have data starting in june 2017 until february 2018:

I created the following columns by the column with the dates, and the Mes (month) column i selected Sort by Column MesNum(MOnthNumber) in Modeling:

But when i tried to use it in a graph, is not appearing order it. I tried in the axis with Month, MonthNum and MonthNum Hierarchy:

What can i do? Im need your experience.
Thank you!!
MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.
8 Replies
- dramusContinued Contributor
By default it's going to sort it alpha-numerically.
You will need to set the "Sort By" column for the Month column to be the numeric month column.