Forum Discussion
Solved
Order month name by calendar sequence
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 !
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 Replies
- Hi , thanks for looking into this. I am applying it to a pivot table.
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
