How to Create a Gantt Chart in Power BI (Fast and Easy)

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

A Gantt chart is one of the most effective ways to show project timelines.

There’s just one problem when creating a Gantt chart in Power BI:

Power BI has no built-in Gantt chart visual.

Fortunately, the story doesn’t end there.

In this article, you’ll learn how to create a Gantt chart in Power BI step by step.

Kasper Langmann, Co-founder of Spreadsheeto

Let’s get started! 😎

*This tutorial is for Power BI Online (also called "Power BI Service").

Introduction to Gantt Charts

A Gantt chart is a type of chart that’s popularly used in project management.

It only serves one purpose:

To graphically display project timelines.

It’s a great way to show information about the estimated time commitments on a project and what’s suppose to happen in a certain period.

The concepts that Gantt chart excellently represents are scheduling and task assignments.

There’s just one problem if you’re thinking of using the Gantt chart in Power BI — no built-in Gantt chart visual.

But there’s a way around that and we’ll be showing you how in this article.

Kasper Langmann, Co-founder of Spreadsheeto

Importing the Gantt Chart

Power BI may have lots of built-in charts. However, it doesn’t have every chart in the world.

That’s where Microsoft’s AppSource comes into play. Here, Power BI users can download custom made visuals and use them for their own reports.

Also, you don’t have to go to the AppSource’s page using your browser. You can access the marketplace straight from Power BI itself.

Here’s how:

Click the ellipsis icon (…) on the visualizations pane.

Then, clickImport from marketplace’:

How to import from the marketplace in Power BI Desktop

That will open the marketplace within Power BI where you can search for custom visuals.

Search for “Gantt”.

Select the one at the top with the verified (checkmark) mark and clickAdd’:

Adding the Gantt chart from Microsoft’s marketplace

Once the chart is successfully loaded, you’ll immediately see its icon on the visualizations pane.

Kasper Langmann, Co-founder of Spreadsheeto

Import from File

If you’ve got a hard time connecting to the marketplace and importing the chart, you can also go to the AppSource directly using your browser and download the visual add-in.

Then, on your Power BI, selectImport from file’ and choose the downloaded add-in.

How to import a visual add-in in Power BI Desktop

Get your FREE exercise file

Before you start:

Throughout this guide, you need a data set to practice.

I’ve included one for you (for free).

Download it right below!

Download the FREE Exercise File

Download exercise file

Importing an Excel Workbook

For this tutorial, we’ll be using the Power BI Desktop as well as the same dataset as our Excel Gantt Chart tutorial.

If you would like to use the same, kindly download the workbook using the link from the previous section.

The same dataset used in Spreadsheeto’s Gantt chart tutorial

To start, click the down arrow on the ‘Get Data’ icon found on the ribbon.

Then, selectExcel’:

Select Excel after clicking the down arrow on the ‘Get Data’ icon

On the Navigator window, select the ‘Schedule’ table only.

Then, clickLoad’:

When importing the workbook, select the ‘Schedule’ table only and click ‘Load’

Creating the Gantt Chart

To start, click the Gantt chart icon on the visualizations pane:

The Gantt chart icon on the visualizations pane

After that, an empty Gantt chart will appear on the canvas.

Looking at the visualizations pane, you’ll see a lot of information you can feed into the chart like:

  • Legend
  • Task
  • Parent
  • Start Date
  • End Date
  • Duration
  • % Completion
  • Resource
  • Tooltips
  • Milestones

Like in any Power BI visual, all you have to do is drag the appropriate fields from the Fields pane to the buckets on the visualizations pane.

Usually, you can check the fields from the Fields pane and they would automatically fill the chart up. However, you would have to drag them one by one so the right field would go to the right bucket.

Kasper Langmann, Co-founder of Spreadsheeto

For example:

  • Column1, which contains the tasks, should go to the ‘Task’ bucket.
  • Duration to the ‘Duration’ bucket.
  • Start Date to the ‘Start Date’ bucket.
Putting the right fields to the right bucket

After that, you would immediately see your Gantt chart filled up with information.

Fast and easy! 👍

Wrapping things up…

It’s true that Power BI doesn’t have a built-in Gantt chart. But that doesn’t mean it’s impossible to make one! As you can see, it doesn’t even take 3 minutes to create one especially if you got your data prepared and ready.

After repeating this a few times, you can proceed to create more advanced Gantt charts. There are still a lot of buckets you can fill in and format capabilities waiting for you. Happy charting! 😄

Kasper Langmann, Co-founder of Spreadsheeto