Sorting by month in Slicers

[Peter_Roel]

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

[#2]

@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'

[#3]

@bhushan_z - Thanks, but I've tried that but doesn't work

[#4]

can u pls share the file

[#5]

@Peter_Roel 

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.

[#6]

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

[#7]

@Peter_Roel , good, thank you for the feedback