not able to sort by months in chronological order

[AbdullahTammour]

Hello All,

I have an Excel table with a date column and the next column contains this formula

=TEXT(B222,"MMMM")

which as you know extracts the month name from the date cell.

when I use Excel to make some data analysis: Excel recognizes that the column contains a month name so when I create a chart or a slicer it sorts the months chronologically (January, February, March, ,...) 

When I tried to use Power BI to create a chart for the same table, Power BI doesn't recognize that the column contains month names and it sorts them alphabetecally (April, February, January,....) or sometimes in unlogical order.

is there a solution for this?

Many thanks in advance.

[TomMartens · Accepted solution]

Hey,

you have to order the column with the month names by a column that contain 1 for January, 2 for February and so on

maybe this will get you startet

https://community.powerbi.com/t5/Desktop/Month-Name-in-sorting-order/m-p/152006/highlight/true#M6575...

You alsoi may try the search "Month" and "Order"

Hope this helps

[v-ljerr-msft · Accepted solution]

Hi @AbdullahTammour,

Have you tried the solution provided by @TomMartens above? It should work in your scenario.

If it works, Could you accept it as solution to close this thread? If you still have any question on this issue, feel free to post here. 

Regards

[TomMartens · Accepted solution]

Hey,

you have to order the column with the month names by a column that contain 1 for January, 2 for February and so on

maybe this will get you startet

https://community.powerbi.com/t5/Desktop/Month-Name-in-sorting-order/m-p/152006/highlight/true#M6575...

You alsoi may try the search "Month" and "Order"

Hope this helps