Can't sort Months

[EricHHA]

I'm having a lot of trouble to just order the months of the char below, chronolagicaly.

I searched on many topics on the internet but I simply don't know how to apply any of them on my case. I can't change my month column to "Date" and also can't create a measure to number it from 1 to 12.

Thanks for anyone who can help

Photos:

https://imgur.com/A8uF7bU

https://imgur.com/ENbKFds

[smearp]

Hello Eric-  

Super common issue!  Since the month names are text, Power BI assumes that you want to sort them alphabetically.

You need to create an additional MonthNumber column (Creating a new conditional column in Power Query is probably where I'd do it) that basically says:

• If Month = Jan, then 1
• If Month = Feb, then 2
• If Month = Mar, then 3
• etc...

Then... in your model, select the month column, choose "Sort by column", and then choose the new MonthNumber column.

[EricHHA]

Tks a lot! It worked pretty fine indeed!

Have a good week.