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 ExcelGantt Chart In ExcelGantt chart is a type of project manager chart that shows the start and completion time of a project, as well as the time it takes to complete each step. The representation in this chart is shown in bars on the horizontal axis. 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 toolPower BI Visualization ToolIn Power Bi, there are some built-in visuals for data visualization, as well as some custom visuals. Custom visuals are user-defined and allow users to use their own creativity in terms of how they want to present data. For example, one can use lines and dots in a flashing and floating manner to display changes in data over time. 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 the 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 the 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 the 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 the visualization list and choose “Import from Market Place.”
- From market place, search “Gantt Chart” in power bi and click on the “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 the “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 the “Resource” column to the “Legend” field.
- Now drag and drop the “Start Date” column to the “Start” field.
- Drag and drop the “Duration” column to the “Duration” field.
- Drag and drop the “% Completion” column to the “% Completion” field.
- One last important thing we need to add is drag and drop the “Resource” column to the “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 barsScroll BarsIn Excel, there are two scroll bars: one is a vertical scroll bar that is used to view data from up and down, and the other is a horizontal scroll bar that is used to view data from left to right. to scroll through each task, which is a frustrating job, but by adding a slicer to the 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 a custom visual.
- Try downloading different kinds of custom visuals for the 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 –