Pivot Table Date Filters not formatting correctly

[MagicMoogle]

Using Excel 365

I have a data set that contains a "month" column formatted to "MMM-YY".

When I pull this column into the filters section of my pivot table, the options are:

"<29/02/2016
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
>01/07/2023"

How do I get it to show my desired formatting IE "Apr-23" etc?

Many thanks in advance.

 

[Shortmeister1]

Two steps:

1. Right click an item in the date column and click ungroup. You should now have a list of raw dates.
2. Now right click one of the dates, select "Field Settings" and then "Number Format". This is where you select your date format.