EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Data Science Data Science Tutorials Power BI learn Power BI Gantt Chart
 

Power BI Gantt Chart

Priya Pedamkar
Article byPriya Pedamkar

Updated March 24, 2023

Power BI Gantt Chart

 

 

What is Gantt Chart?

The Gantt chart, often used in project management, is among the most popular and useful ways to view activities (tasks or events) on time.t is a Gantt chart, a handy tool of project management professionals that are heavily used to track projects. Gantt chart essentially converts the project information to visual representation. It is much easier to monitor the progress of a project through a visual representation rather than actually going through the data. Power BI offers a very up-to-date Gantt chart functionality using which an insightful Gantt chart can be built.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Components of Power BI Gantt Chart

A Gantt chart is made of some important components. These are as follows:

1. Task: Tasks are basically activities involved in the project.
2. Duration: It refers to the estimated timeline for the completion of each task.
3. Start: A date on which execution of a task shall begin.
4. %Completion: It essentially shows how much of the task work has been completed.
5. Resource: Technical, domain, or other experts required in the project.

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.

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

How to Create Gantt Chart in Power BI?

In the following section, we will go through the detailed step-by-step process to create Gantt Charts in Power BI.

  • Step 1: Load the dataset into Power BI. For that click on Get Data Menu under Home Tab. From the drop-down menu of Get Data, select appropriate data source type. In this case, it is Excel, so clicked on Excel as shown by the below screenshot.

 Example 1-1 (Menu Ribbon)

  • Step 2: Select the files from the location it is stored. Once the requisite dataset is selected, in the Navigator window, select the appropriate sheet from the Excel workbook, and then click on Load.

Example2 (Navigator Window)

  • Step 3: The data gets loaded into Power BI. Requisite dimensions and measures present in the dataset can be seen on the right side of the screen.

Example3 (Fields)

  • Step 4: Note, in the above screenshot, in the Visualizations section we cannot find the Gantt chart. This is because, Gantt chart is not available directly, and it needs to be imported as a custom visual. For this, click on “Import a custom visual” symbol as highlighted below.

Power BI Gantt Chart Example 4

  • Step 5: The Gantt chart needs to be imported from the marketplace, and so click on the “Import from marketplace” option.

Example 5 (Visualizations)

  • Step 6: One needs to be registered through the official email id. Sign in to have access to the marketplace.

Power BI Deskstop (Sign in)

  • Step 7: In the marketplace window, in search, type “Gantt” to discover all available Gantt chart options. This is as shown below. We get a list of Gantt charts, Just click on the Add button to add the chart to the Visualizations section.

Power BI Gantt Chart Example 7

  • Step 8: Once the chart is imported into the Power BI environment, we get a success message as shown.

Power BI Gantt Chart Example8

  • Step 9: The imported Gantt chart can be found in the Visualizations section. It has been highlighted in the below screenshot.

Example 9 (Visualizations)

  • Step 10: The chart can be brought into the analysis. For this click on the newly brought Gantt chart symbol as shown below.

Power BI Gantt Chart Example 13

  • Step 11: Gantt chart is made of certain components. As a visualization giving clear details of the project schedule and assisting project managers in monitoring the task, it must make use of each component judiciously. Power BI as a visual analytics tool very well ensures that Gantt chart for a project gives the details in the most effective manner.

Example (Task Name)

In order to generate an insightful Gantt chart, we must drag dimension or measure over corresponding components in the Fields section. We’ll drag each of them one-by-one sequentially. Let’s first start with Task Name. Drag Task Name dimension over Task in Fields section. Ensure that while dimension or measure is being dragged over the corresponding field, closely observe how the Gantt chart is getting affected.

  • Step 12: Now, drag Start over Start in Fields.

Power BI Gantt Chart Example 14

  • Step 13: Now, drag measure Duration over Duration in Fields.

Example 13 (Duration in Fields)

  • Step 14: Now, drag %Completion measure over % Completion in the Fields section.

 Example 14 (Completion)

  • Step 15: Finally drag Resource over Resource in Fields. Remember Resource is a very crucial component of a project, and a Gantt chart must have it.

Power BI Gantt Chart Example 18

  • Step 16: When we perform the above steps properly, we end up getting a Gantt chart as shown by the following screenshot. Here, the Gantt chart has two colors, light green and dark green. The former corresponds to Duration, while the latter corresponds to %Completion. In this way, the Gantt chart in Power BI provides us detailed insights into the project schedule. However, in the below chart, the size of the text is too small. We’ll overcome this issue by following the steps mentioned in the subsequent section.

Power BI Gantt Chart Example 19

  • Step 17: In the View tab, under the “Page View” menu, select “Actual Size”, and click on it. This is illustrated by the below screenshot.

Power BI Gantt Chart Example 20

Following the above steps, we get an insightful Gantt chart. Now, we can see that the size of the text has increased considerably. We can view the requisite part of it using scrolls.

Power BI Gantt Chart Example 21

  • Step 18: As we can see above, the Task Names have got slightly buried, and we cannot view the names clearly. In order to overcome this, we can use a Slicer, so that the task names can be viewed properly. The following screenshot shows a slicer being added to facilitate easy task selection.

Power BI Gantt Chart Example 22

Slicer also allows us to select tasks as per our requirements and analyze the project schedule. This is as shown below.

Power BI Gantt Chart Example 23

Note: Power BI dashboard file can also be downloaded from the link below and the final output can be viewed.

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

Things to Remember

  • Gantt chart as functionality is not available directly and needs to be imported from the marketplace.
  • Gantt chart has various components, and all these must be taken into consideration. Moreover, they must correspond to the respective fields.
  • In the marketplace, various types of Gantt charts are available. It’s always good to explore each of them one-by-one, in order to discover the uniqueness offered by each of them.

Recommended Articles

This is a guide to Power BI Gantt Chart. Here we discuss how to Create Power BI Gantt Chart to essentially convert the project information to visual representation along with a practical example. You may also look at the following articles to learn more –

  1. Use of Power BI IF Statement
  2. Power BI Calendar(Examples)
  3. Power BI Tooltips | Creating Report Page Tooltips
  4. How to Create Power BI Bubble Chart?
  5. Guide to Power BI Bullet Chart
  6. Steps of Power BI Charts
  7. Power BI Themes | How to Set?

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Power BI Gantt Chart Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Power BI Gantt Chart Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW