While working on project tracking dashboards, I got a requirement to display task timelines with highlighted important checkpoints, such as planned start, planned finish, and actual milestones. Using a simple bar chart, we can only show the duration, but I also had to display milestone markers on the timeline.
For this data visualization, I used the Tableau Gantt chart and displayed the date milestones on it.
In this tutorial, I will explain how to create a Tableau Gantt chart with milestones. In this chart, tasks will be displayed as bars, and milestone dates will be represented as shapes.
With this chart, we can track both the overall duration of tasks and the critical dates in project management.
Tableau Gantt Chart With Milestones
In Tableau, a Milestone Gantt Chart is a project management visualization chart that combines task timelines with milestone markers. The horizontal bars represent the start and end dates of tasks, while milestones are shown as shapes like circles or diamonds that are placed on specific dates, such as planned start, planned finish, actual start, and actual finish.
Using the Tableau Milestone Gantt Chart, it is easier to compare planned vs. actual progress and identify where tasks are on track or delayed.
For example, a task was planned from 1st to 10th August, but actually ran from 3rd to 12th August. The chart will display the planned bar, along with markers for the actual start and finish, highlighting the delay with the milestone date.
Create a Gantt Chart With Milestones in Tableau
To create a Tableau Gantt chart with milestones in Tableau, I have created a sample project management data set. You can use the same data set to create a milestone Gantt chart in Tableau.
Now, connect the datasource with Tableau and follow the steps below to create a Gantt chart with milestones in Tableau.
- Create a calculated field “Duration” to calculate the number of days between the start and end dates. Enter the formula below in the calculated field.
DATEDIFF('day', [Start Date], [End Date])
- Drag the Task to the Rows and Start Date to the Columns.

- By default, the Start date will be in the Year format. Click on the Start Date and select the date format as Day(continuous).

- In the Marks section, set the chart type to Gantt Bar.

- To show the size of the bars in the Gantt chart, add the calculated field to the Size card in the Marks section.
