KNOWLEDGE BASE

How to Move Date Headers to the Top of a Column


Published: 05 Sep 2013
Last Modified Date: 24 Oct 2017

Question

How to display date labels as headers at the top of columns.

Environment

Tableau Desktop

Answer

Option 1

Use a discrete date.

Option 2

The following instructions can be reviewed in the workbook attached below.
  1. Drag Order Date to the Columns shelf.
  2. Drag Sales to the Rows shelf.
  3. Right-click YEAR(Order Date) and select the second Month option.
  4. Right-click Order Date and select Duplicate.
  5. Drag Order Date (copy) to the Columns shelf.
  6. Right-click YEAR(Order Date (copy) and select the second Month option.
  7. Right-click the MONTH(Order Date) field on the Columns shelf and select Dual Axis.
  8. Right-click the bottom axis and select Edit Axis.
  9. Delete the text in the Title field on the General tab.
  10. Click on the Tick Marks tab.
  11. Select None under Major tick marks and Minor tick marks.
  12. Click OK.
Did this article resolve the issue?