Forum Discussion
Sorting by month in Slicers
Hi,
Somehow I am not able to sort my slicer by Months from Jan to Dec.
It's sorted in Pivot Table and Chart but in slicer it starts with Apr, Feb, Jan, etc..
I tried to solve it in slicer settings and also via Options>Advanced>Edit Custom Lists>Import list from cells but no luck.
Thanks
Peter
6 Replies
Most probably creating the PivotTable you added data to data model (default behaviour).
If so you ma re-create the table without data model; or add one more column with month numbers and in Power Pivot sort months by this column.
SergeiBaklan Thanks you!!. I've added an extra column with the month numbers and now sorting works.
Peter_Roel , good, thank you for the feedback
- can u pls share the file
Peter_Roel it can be done via Slicer Settings,
Item Sorting > Ascending (Oldest to Newest)Also check your months are saved as months and not as 'text'
bhushan_z - Thanks, but I've tried that but doesn't work 😞
