Last Modified Date: 20 Dec 2019
AnswerUse the following workaround.
- In Tableau Desktop, select Analysis > Create Calculated Field.
- In the Calculated Field dialog box that opens, enter a name for the field. In the example packaged workbook, the field is named Begin Date.
- In the formula field, create a calculated field similar to the following:
STR( CASE MONTH([Order Date] )
WHEN 1 THEN "January"
WHEN 2 THEN "February"
WHEN 3 THEN "March"
WHEN 4 THEN "April"
WHEN 5 THEN "May"
WHEN 6 THEN "June"
WHEN 7 THEN "July"
WHEN 8 THEN "August"
WHEN 9 THEN "September"
WHEN 10 THEN "October"
WHEN 11 THEN "November"
ELSE "December" End)
+" "+STR(DATEPART('day', [Order Date] ))+", "+STR(DATEPART('year', [Order Date] ) )
where [Order Date] is the date field being used in the sample workbook view. Click OK.
- Drag Order Date to Rows.
- Right-click Order Date on Rows, and then select More > Custom > Month / Day / Year. Click OK.
- Right-click Order Date again and clear the check mark next to Show Header.
- Drag Begin Date to Rows.
Additional InformationThe procedure described in the Renaming Measures in the View Community post lets you change headers for other measures in the view, but not for dates.
To voice your support for the inclusion of this feature request in a future product release, add your vote to the following Community Idea: Ability to rename the Month names in date field headers.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials