Search code examples
tableau-apidashboardtableau-desktop

Change Tableau's Automatic Labels for a Text Table

I am making a small summary table in Tableau. I want the full date to be shown (day, month, and year), but when I select the DAY() option, it changes the column title from "Date Initiated" to "Day of Date Initiated" which makes no sense. How can I change the column title in this Tableau table?

enter image description here

When I right click, I don't have an "Edit Alias" option like I would for a non-date column.

enter image description here

Solution

  • 3 ways: 1.You can change the data type from Date to String. This will show the full date and you can also alias, if needed.

    2.You can create a calculated field using STR(Date Initiated). Same as above, this will show the full date and you can also alias, if needed.

    3.You can use the discrete custom date part Month / Day / Year option using the Custom date selection in the dimension dropdown menu. See images.

    Select More -> Custom

    Select Month / Day / Year

    Result