How to Sort Month Names Chronologically in a Slicer?"

[Em1278]

I am using a direct query and do not have the access to the data. Hence I cannot use 'sort by' other column to sort the months in chronological order. Is there any other way to get the months in chronological order inside the slicer.

Currently, I am getting the below sequence.

[lbendlin · Accepted solution]

Use a calendar table that has Month Name and Month Number columns. Sort the name by the number.  Join the table to your Month Name column in your data source. Use the Month Name from the new table for the slicer.

[Anonymous · Accepted solution]

Hi, @Em1278 

The solution offered by lbendlin's is very effective. 

And I would like to share some additional solutions below. 

You can also customize the sorting based on fields in the Power Query Editor. 

First click Transform data, then click Column From Examples: 

Below you can customize the sorting by field, then click close&apply: 

Sort MonthName by SortNum: 

Result： 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Use a calendar table that has Month Name and Month Number columns. Sort the name by the number.  Join the table to your Month Name column in your data source. Use the Month Name from the new table for the slicer.