We all know what a Gantt chart is and we know that it is a representation of the timeline for a given project from start to finish with all the steps from starting and all the process involving and finishing time of the project, Microsoft has also integrated a visualization technique to represent data in the form of Gantt charts.
What is the Gantt Chart?
Gantt Chart in Excel is a visual representation of the progress of tasks against the set timeline. So through this chart, we can oversee each task activity against the set deadline. A Gantt Chart usually showed in the horizontal line axis represents the total time required to complete the task. We have a Power BI visualization tool to create a beautiful Gantt Chart.
Below are the key parts of the Gantt Chart.
- Task Name: It is important to have each task name in detail, the same will be displayed on the chart horizontally against each horizontal axis bar.
- Time Duration: Against each task what is the time duration to complete the task.
- Date Values: For each task what is the projected starting date.
- Completion Percentage: Once the deadline crosses for each task what is percentage completion for each task.
To create Power BI Gantt Chart you need data to work with, so you can download the excel workbook template from the below link which is used for this example.
How to Create Gantt Chart in Power BI?
To create Gantt Chart in Power BI we need a set of data that has all the above elements of Gantt Chart.
Below is the simple task list to create Gantt Chart in Power BI.
Note: Data source is from Microsoft.
- Copy the above table to excel worksheet and then upload the data to Power BI.
- Unfortunately “Gantt Chart” isn’t the built-in chart which can be used straight away, so we need to import from market place to use it.
- Go to visualization list and choose “Import from Market Place”.
- From market place search “Gantt Chart” in power bi and click on “Add” button.
- Now we can see this visual under our visualization list.
- By clicking on this insert blank “Gantt Chart”.
- Using the fields of “Gantt Chart” we will build the “Gantt Chart” for the uploaded data. The first thing we need to do is to drag and drop “Task Name” to “Task” field of the chart.
- Now we can already see how power bi in Gantt Chart shaping up.
- The second item we need to drag and drop is “Resource” column to “Legend” field.
- Now drag and drop “Start Date” column to “Start” field.
- Drag and drop “Duration” column to “Duration” field.
- Drag and drop “% Completion” column to “% Completion” field.
- One last important thing we need to add is drag and drop the “Resource” column to “Resource” field.
- Now we have the “Gantt Chart” in power bi is look like this.
On the left-hand horizontal side, we can see “Task List Names” and on the top horizontal line we can see “Start Date”. Each bar represents each task completion percentage, if the bar is fully filled then that is considered as 100% completed or else we can see the percentage completion percentage.
Since the task list and duration is long we need to use scroll bars to scroll through each task which is a frustrating job, but by adding a slicer to task list we can filter each task and see what is happening.
- Insert slicer and add the filed as “Task Name”.
- Now if you click any specific set of the task only those tasks Gantt Chart will be displayed. Now I have chosen three tasks from the slicer and now we can see only those three tasks Gantt Chart.
Note: Power BI dashboard file can also be downloaded from the link below and the final output can be viewed.
Things to Remember Here
- Gantt Chart is not a built-in chart, so we need to import it as custom visual.
- Try downloading different kinds of custom visuals for Gantt Chart.
- Data should include all the necessary fields as shown above.
This has been a guide to Power BI Gantt Chart. Here we learn how to create a Power BI Gantt chart to visualize the progress of tasks against the set timeline. You may learn more about Power BI from the following articles –