BUSINESS, Custom Visuals, GEEK, Power BI, Project Online

by Allan Rocha, MVPMarch 10, 201610:48

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:

First of all, download the Power BI Custom Visual Gantt: https://app.powerbi.com/visuals/
Make sure you have the latest version of Power BI Desktop, in case you are using it.
If you want to create the report directly into Power BI, you are always using the latest version!

Under visualizations, click on Import.

Select you Gantt.pbiviz file

Click on the Gantt icon, under visualizations, to add the visual
Look at the fields available for this chart
- Legend
- Task
- Start Date
- Duration
- % Completion
- Resource

I’m using the following tables for this chart
- Assignments
- Resources
- Tasks
I’m placing the fields on the following order:
- Legend: Role (Resource)
- Task: TaskName (Assignments)
- Start
  Date: AssignmentStartDate (Assignments)
- Duration: TaskDuration (Tasks)
- %
  Completion: TaskPercentWorkCompleted (Tasks)
- Resource: ResourceName (Resources)

Add some extra charts, slicers and make it look good
DONE!
You have now your Power BI Gantt Chart ready to use!

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

Access your Power BI Report
Remember to Enable custom visuals.

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

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/

18Comments

Add yours

1

Anand Kumar R on March 10, 2016 at 12:53
Reply

This is a fabulous update for Power BI Allan, Thank you once again for sharing it (:

LikeLike
2

Rodrigo on March 10, 2016 at 14:12
Reply

It would be a good idea to show the measures you created as the data model.

LikeLike
- 3
  
  Allan Rocha, MVP on March 10, 2016 at 14:17
  Reply
  
  Hi Rodrigo,
  I’m using the Project Online OData feed as source.
  So, my data model is based on that. Didn’t create anything special.
  
  The entire schema is available here:
  Schema: ReportingData (ProjectData service)
  
  LikeLike
  - 4
    
    Allan Rocha, MVP on March 10, 2016 at 14:27
    
    But, of course, it can also be complex… 🙂
    Just for fun:
    
    another one:
    
    LikeLike
5

Daniele on March 10, 2016 at 18:03
Reply

Thanks Allan,
this is a good solution for External user collaborating in the project to share the gantt chart with them, publishing the report directly on the site. Great Power BI.
A question: did you find the “Task Note” field in the schema??? I’d like to reporting on that..

LikeLike
6

Daniele on March 10, 2016 at 18:23
Reply

Allan, in the second schema you posted, “Snapshot” and “Financials” are coming from SharePoint lists? Are they related to apps Microsoft recently acquired?
Thanks

LikeLike
7

Rich Garlock on March 13, 2016 at 18:42
Reply

That’s a great feature to know about. Thanks, Allan!

LikeLike
8

Chad Olson on March 15, 2016 at 22:33
Reply

For task duration it uses work days and thus the dates don’t line up. To get calendar days you can subtract Finish Date and Start Date from the date transformation item in the ribbon. I also suggest using Percent Complete rather than Work Percent Complete since you are looking at dates with the Gantt chart.

LikeLike
- 9
  
  Abe K on June 27, 2016 at 04:31
  Reply
  
  Chad … Can you give the formula for this please. I am struggling to get actual number of days on the Gantt
  
  LikeLike
10

Nav on March 20, 2016 at 23:06
Reply

Allan, I am stuck at loading of these tables. There is too much data and it goes on loading for about 30 mins and more and then I cancelled it. Is there an efficient way to connect to the tables : Assignments, Resources and Tasks

LikeLike
11

Ville on April 25, 2016 at 11:48
Reply

Allan, looks like your report is suffering from the same timeline date issue that I am suffering from. (All task start dates and months in 01). Any insight into when this could be fixed?

LikeLike
12

Atul J on October 14, 2016 at 17:55
Reply

Hi. I am trying to group the start date by quarters. I think leadership prefers Quarter more, when the data is spread across years. Please let me know if the Gantt data type can have quarter selection as well?

LikeLike
13

Pablo on February 28, 2017 at 14:21
Reply

Great post! Is there anything like this for Power View and/or PowerPivot?

LikeLike
14

Luke on June 22, 2017 at 00:45
Reply

Can Someone please explain how to create those blue links that navigate to different timelines in the first screen shot of this article? It would be really handy to be able to click on different departments and pull up the timelines for each separately.

Thanks!

LikeLike
- 15
  
  Allan Rocha, MVP on June 22, 2017 at 21:02
  Reply
  
  Hi Luke,
  Pretty simple…
  
  Visualization: Slicer
  
  Then go to details and change the orientation to: Horizontal
  
  🙂
  
  LikeLike
16

David Marín on October 5, 2017 at 23:46
Reply

Hi, Can you display only working days on the date axis?

LikeLike
17

Patricia Bailey on July 11, 2018 at 02:14
Reply

Allan, Can you explain the Horizontal slicer. I have changed it to horizontal, but i’m not seeing how you are able to navigate different timelines. its only filtering my data using the same chart, not changing to a different chart?

LikeLike
18

javad on September 28, 2018 at 20:06
Reply

HI
how can i have actual and plan bar beside anther?

LikeLike

Share this: