Showing Continuous Month or Day Level Data for Multiple Years on the Same Chart

Published: 07 Nov 2017
Last Modified Date: 18 Jul 2018


How to show continuous month/day level data for multiple years on the same graph.


Tableau Desktop


Creating a calculated field that pulls out the month/day data without the year. The attached example workbook uses the sample data set Superstore to demonstrate the following directions:
  1. Drag [Sales] onto the Rows shelf.
  2. Drag [Order Date] onto Color on the Marks card.
  3. Create a calculated field with a name like "Date without year" with a calculation similar to the following:
    DATE(MONTH([Order Date]) + DAY([Order Date])+ YEAR(TODAY()))
    • All dates in Tableau Desktop must have a year, but for the chart we want all data on the same month/day to be grouped despite the year.
    • Therefore we have given all of the date values the same year.
  4. Right-click and drag [Date without year] to the Columns shelf.
  5. In the Drop Field dialog, select the green (or continuous) DAY(Date without year) and click OK.

Did this article resolve the issue?