Abbreviating Month Names

Product(s): Tableau Desktop, Tableau Public, Tableau Public Premium
Version(s): All
Last Modified Date: 16 Aug 2016

When drilling down to the month level of a date field, by default Tableau will use full month names, such as January, February, March, etc. This can sometimes take up more space on a view than you want.

This article shows how to display month abbreviations using either three-letter abbreviations (Jan, Feb, Mar, etc.) or one-letter abbreviations (for example, J, F, M, etc.).

Create the view

The following example uses the Sample - Superstore data source that is included with Tableau Desktop.

Step 1 

From the Dimensions area of the Data pane, drag Order Date to Columns , right-click YEAR(Order Date) , and choose Month. (Month actually appears twice in the listing—choose the first one, which specifies a discrete date. )

Step 2 

From the Measures area of the Data pane, drag Sales to Rows.

Step 3 

Right-click the MONTH(Order Date) field, and click Format.

Step 4 

In the Format window, next to Dates, select Abbreviation to display the month name with three letters, or select First Letter to display the month name with one letter.


Did this article resolve the issue?