How to switch slicer order from alphabetical to chronological

Hi there,

Without seeing the data you are using, some suggestions to try:

Make sure your 'months' are actual dates, not text. Text would show alphabetically.

In the pivot table where you get the dates from, check the settings for the pivot date settings. Right-click on a date and select 'Group...'.
Make sure you have Months (and probably 'Years') highlighted. The pivot table will now have the records grouped by month in chronological order.
Adding a slicer for the dates now should give you the same order; Jan > Dec.
If you need to show your records by date, change the pivot table field setting and add 'Days'. The slicer should keep only showing months.

If your data can't be summaried, you could use a 'helper column' in your source data, call it 'Month' for example.
Here you get the number the month is representing (Jan = 1... Dec = 12), then show the abbreviation for the month;

Formula:

Please Login or Register  to view this content.

Then base the slicer on that column.

Also make sure that in the Slicer > Slicer Options the sort order is set to Ascending (A-Z).

Hope this helps.