KNOWLEDGE BASE

How to Show the Date Axis in Separate Rows


Published: 07 Sep 2021
Last Modified Date: 08 Sep 2021

Question

How to show the date axis in several rows like the image below.

First Line: Month
Second Line: Year

User-added image
 

Environment

  • Tableau Desktop

Answer

The ability to show the date axis in several rows is not currently built into Tableau Desktop.

Workaround
Use several STRING lines to show the date axis.

1. Create a string field like below
========
STR(MONTH([Order Date])) + 
"
"
+STR(YEAR([Order Date]))
========

2. Use the String field as the date axis

3. Sort the string field to show the right date order.
User-added image

Please check the attached workbook for details.
Did this article resolve the issue?