Power BI Gantt Chart

Updated on January 2, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

We all know what a Gantt chart is. We know that it represents the timeline for a given project from start to finish with all the steps from starting and all the processes 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.read more 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 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.read more to create a beautiful Gantt Chart.

Below are the key parts of the Gantt chart.

  1. 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.
  2. Time Duration: Against each task, what is the time duration to complete the task.
  3. Date Values: For each task, what is the projected starting date.
  4. Completion Percentage: Once the deadline crosses for each task, what is the percentage of completion for each task.
Gantt-Charts-in-Power-BI-Desktop-1.png

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Power BI Gantt Chart (wallstreetmojo.com)

You need data to work with to create the Power BI Gantt chart. So, you can download the Excel workbook template from the link below, which is used for this example.

You can download this Power BI Gantt Chart Excel Template here – Power BI Gantt Chart Excel Template

–>> If you want to learn Power BI professionally, then Power BI Basics Course (5+ hours) is the perfect solution. This course will introduce you to a wide range of Power BI concepts like collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights, Creating Reports in Power BI Desktop, Analyze Data with Excel, Graphs & Visualizations, Interactive Dashboards along with some real life examples.

How to Create Gantt Chart in Power BI?

To create a Gantt chart in Power BI, we need a data set with all the above elements of the Gantt chart.

Below is the simple task list to create a Gantt chart in Power BI.

Note: Data source is from Microsoft.

Gantt Charts in Power BI (Data)
  • Copy the above table to the Excel worksheet and then upload the data to Power BI.
Gantt Charts in Power BI (upload data)
  • Unfortunately, “Gantt Chart” is not a built-in chart we can use immediately. So, we need to import from the marketplace to use it.
  • Go to the “Visualizations” list and choose “Import from marketplace.”
Gantt Charts in Power BI (visualization list)
  • Search “Gantt Chart” in Power BI from the marketplace and click on the “Add” button.
Add Gantt Charts in Power BI
  • Now, we can see this visual under our visualization list.
Gantt Charts in Power BI
  • By clicking on this, insert the blank “Gantt Chart.”
Open Gantt Charts in Power BI
  • Using the fields of “Gantt Chart,” we will build the “Gantt Chart” for the uploaded data. We first must drag and drop “Task Name” to the “Task” field of the chart.
Gantt Charts in Power BI (Add task name)
  • We can see how Power BI in Gantt Chart is shaping up.
Gantt Chart shaping up
  • The second item we must drag and drop is the “Resource” column to the “Legend” field.
Add Resource
  • Drag and drop the “Start Date” column to the “Start” field.
Add Date
  • Drag and drop the “Duration” column to the “Duration” field.
Add Duration
  • Drag and drop the “% Completion” column to the “% Completion” field.
Add % Completion
  • We must add another important thing to drag and drop the “Resource” column to the “Resource” field.
Again add resource
  • Now, the “Gantt Chart” in Power BI looks like this.
Create Gantt Chart

On the left-hand horizontal side, we can see “Task List Names.” On the top horizontal line, we can see “Start Date.” Each bar represents each task completion percentage. If the bar is filled, that is considered 100% completed. 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.read more to scroll through each task, which is frustrating. But, by adding a slicer to the task list, we can filter each task and see what is happening.

  • Insert slicer and add the file as “Task Name.”
Add task name 1
  • Now, if you click any specific task set, it will display only those tasks Gantt chart. So, for example, we have chosen three tasks from the slicer and can see only those three tasks in the Gantt chart.
Add three tasks

Note: We can also download the Power BI dashboard file from the link below. Finally, we can view the final output.

You can download this Power BI Gantt Chart Template here – Power BI Gantt Chart Template

Things to Remember Here

  • The 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.
  • The data should include all the necessary fields, as shown above.

This article is 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: –