Month Name Slicer - Sort by Months and not by alphabets

[Anonymous]

I am usnig the below slicer by giving the months from a date table. However the months are not ordered as expected based on calender months. It is ordered based on alphabets. 

How to order it based on months ?

[speedramps]

Please consider this solution and leave kudos

Try use a calendar table with date, month number and month name

In the modeller click on month name > sort by column > month number

see https://youtu.be/NlX7Cp2P0d4

[manikumar34]

@Anonymous , 

Sort MonthName column by Month Number.

Regards, 

Manikumar

[amitchandak · Accepted solution]

@Anonymous , In your table you you need month number  and sort month on that

month no = month([Date])

you can sort month on month no.

refer steps: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

[nosirui54]

Thank you this help me.