Forum Discussion

rogletree's avatar
rogletree
Icon for Helper III rankHelper III
6 years ago
Solved

Date format in slicer

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?

Need Help

4 Replies

    • rogletree's avatar
      rogletree
      Icon for Helper III rankHelper III
      6 years ago

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

  • Daviejoe's avatar
    Daviejoe
    Icon for Memorable Member rankMemorable Member
    6 years ago

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

  • Daviejoe's avatar
    Daviejoe
    Icon for Memorable Member rankMemorable Member
    6 years ago

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