• Allan Rocha

Creating a Gantt Chart of your Projects Tasks and Resources in Power BI

Today we will make an AMAZING REPORT with the brand new Power BI Gantt Custom Visual.

Gantt Published by Microsoft

A Gantt chart is a type of bar chart which illustrates a project timeline or schedule. The Gantt Chart visual shows the Tasks, Start Dates, Durations, % Complete, and Resources for a project. The Gantt Chart visual can be used to show current schedule status using percent-complete shadings and a vertical “TODAY” line. The Legend may be used to group or filter tasks based upon data values.

So, this visual is mostly what we are going to use today! Let’s get started:

  1. First of all, download the Power BI Custom Visual Gantt: https://app.powerbi.com/visuals/

  2. Make sure you have the latest version of Power BI Desktop, in case you are using it.

  3. If you want to create the report directly into Power BI, you are always using the latest version!

  1. Under visualizations, click on Import.

  1. Select you Gantt.pbiviz file

  1. Click on the Gantt icon, under visualizations, to add the visual

Look at the fields available for this chart

  1. Legend

  2. Task

  3. Start Date

  4. Duration

  5. % Completion

  6. Resource

I’m using the following tables for this chart

  1. Assignments

  2. Resources

  3. Tasks

I’m placing the fields on the following order:

  1. Legend: Role (Resource)

  2. Task: TaskName (Assignments)

  3. Start Date: AssignmentStartDate (Assignments)

  4. Duration: TaskDuration (Tasks)

  5. % Completion: TaskPercentWorkCompleted (Tasks)

  6. Resource: ResourceName (Resources)


  1. Add some extra charts, slicers and make it look good

  2. DONE!

  3. You have now your Power BI Gantt Chart ready to use!

  1. Let’s publish to Power BI by clicking on Publish.

  1. Access your Power BI Report

  2. Remember to Enable custom visuals.

  1. Enjoy the quick gif showing how cool it is in real life:

Power BI Gantt Chart

In case you don’t know, Power BI has a gallery of visuals created by the Power BI community. you can browse through the visuals or submit one of your own for others to use. SUPER COOL!

https://app.powerbi.com/visuals/

#BUSINESS #CustomVisuals #GEEK #PowerBI

8 views0 comments