CODEWITHSUNDEEP
tableau-apidashboardtableau-desktop
325
325

Reputation: 606

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

Upvotes: 0

Views: 346

Answers (2)

Max
Max

Reputation: 11

One simple way is a hack (as always in Tableau) :

  1. Change the format of your date to TEXT.
  2. Insert your data into your tab.
  3. Go to "Data source" and change the format to Date.

You should see your date values displayed correctly as DD/MM/YYYY.

Upvotes: 1

Fosstin
Fosstin

Reputation: 141

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

Upvotes: 1

Related Questions