Order month name by calendar sequence

[ImalkaJ]

Hi Excel experts,

This is Excel 365. I use Power query to get data and there is a column in data format. I want the calendar month in a slicer

1) I used Month.name on Power query to derive the month name. It was correct . It is in Text format. I tried to change the data type to Date and it resulted in an error. So I kept it as Text.

2) I got the calendar months on the slicer , but it is on Alphabetical order. I want to show it by calendar sequence. 

How can I do it? Thanks !

[#2]

@ImalkaJ 

Do you apply slicer to Table or to PivotTable? Slicer itself shall be sorted correctly

[#3]

Hi , thanks for looking into this. I am applying it to a pivot table.

[#4 · Accepted solution]

@ImalkaJ 

In PivotTable where data is adding to data model add one more column to the table in Power Pivot

 next Month

and sort Month by Month Number

[#5]

Thanks! This worked

[#6]

@ImalkaJ , glad it helped