Date format in slicer

[rogletree]

I am making a visual using date as a slicer.

When I have the data type set to Date, it shows up in the slicer like this:

When I have the data type set to Text, it shows up in the slicer like this:

I like the second way better, but I'd rather keep the data type as Date rather than Text. Is there a way to keep the data type as Text but have it displayed as the other way?

[CNENFRNL · Accepted solution]

Hi, @rogletree , you may want to set date format this way,

[rogletree]

That did it, thank you! I was looking in the wrong spot for changing the format.

[Daviejoe]

Apologies your date format would be "mm/dd/yyyy"

[Daviejoe]

Have you tried changing the format of your date column to "dd/mm/yyyy" or to your preferred formatting?