Pivot Slicer Help

[surkdidat]

I have a column in my data where an individual started, whereby I want to introduce a slicer, but I want it month by month, in month year order (as words)

Column A -Start Date	Column B - Region	Column D - Leaving Reason
01/01/2023	East	Dismissed
23/01/2023	West	Mutual Agreement
01/02/2023	West	Dismissed
15/02/2023	North	Moved Branch
28/03/2023	South	Notice Given

So, in column A I have the start date. However in the slicer, I want the use to be able to pick the month year (ie Jan 2023). I can do this by making it text =TEXT(A2,"yyyy mm") to get 2023 01 etc, but for the user in the slicer I would prefer

Jan 2023
Feb 2023
Mar 2023

etc

Is there an easy way of achieving this please (rather than doing it =TEXT(A2,"mmm yyyy") and then having the list in alphabetical order

 

[Trevor G]

You could add a helper column and use the date column and reformat it to use mmm yyyy that will give you a slicer for month year.

 

[Trevor G]

If you convert your data to a Pivot Table then under the Pivot Table Analyze Tab which is invoked whilst your in the Pivot there is a Timeline Slicer which will provide you with the option you want in addition to what I have suggested previously.