Sorting by month in Slicers

Copper Contributor

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.

 

Capture.PNG

 

Peter_Roel_0-1589969004143.png

 

Thanks

Peter

6 Replies

@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 :(

can u pls share the file

@Peter_Roel 

Most probably creating the PivotTable you added data to data model (default behaviour).

image.png

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.

@Sergei Baklan Thanks you!!. I've added an extra column with the month numbers and now sorting works.

@Peter_Roel , good, thank you for the feedback