Last Modified Date: 20 Jul 2023
Environment
Tableau DesktopAnswer
Option 1
Use a discrete date.Option 2
The following instructions can be reviewed in the workbook attached below.- Drag Order Date to the Columns shelf.
- Drag Sales to the Rows shelf.
- Right-click YEAR(Order Date) and select the second Month option.
- Right-click Order Date in the Dimension Pane and select Duplicate.
- Drag Order Date (copy) to the Columns shelf.
- Right-click YEAR(Order Date (copy) and select the second Month option.
- Right-click the MONTH(Order Date) field on the Columns shelf and select Dual Axis.
- Right-click the bottom axis and select Edit Axis.
- Delete the text in the Title field on the General tab.
- Click on the Tick Marks tab.
- Select None under Major tick marks and Minor tick marks.
- Click OK.
- Right-click on the lower axis again and select Format.
- Click the Borders icon to display more formatting options.
- In the Column Divider Option, click Header > None.
Additional Information
To view Option 2 in action, see the video below:Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials