Loading...
Quick Links

How to Create an Amazing Gantt Chart in Power BI

In this article you’ll learn how to create an amazing report with the new Microsoft Power BI Gantt Custom Visual. A Gantt chart is a kind of bar chart that shows a project timeline or schedule. As Microsoft notes in its Power BI gallery listing for the Gantt chart, the visual you’ll be working with here “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.”

Let’s get started.


Allan Rocha also presented a webinar for MPUG members on how to report your Project Online resource engagements data using Power BI custom visuals.


First, make sure you’re working with the latest version of Power BI Desktop. (If you’re using the cloud version of Power BI), you already know you have the latest edition. Next, download the Power BI Custom Visual Gantt.  The gallery is a collection of interactive reports created by Microsoft folks and others in the Power BI community who have donated their efforts to the roster.

Allan_Rocha_Gantt_chart_in_PowerBI_figure_1

Under visualizations, click on Import.

Allan_Rocha_Gantt_chart_in_PowerBI_figure_2

Select the Gantt.pbiviz file.

Allan_Rocha_Gantt_chart_in_PowerBI_figure_3

Allan_Rocha_Gantt_chart_in_PowerBI_figure_4

Click on the Gantt icon, under visualizations, to add the visual and look at the fields available for this chart (Legend, Task, Start Date, etc.).

Allan_Rocha_Gantt_chart_in_PowerBI_figure_5

For the chart we’re creating, I’m using the following tables:

  • Assignments;
  • Resources; and
  • Tasks.

We’ll place the fields in the following order:

  • Legend: Role (Resource)
  • Task: TaskName (Assignments)
  • Start
  • Date: AssignmentStartDate (Assignments)
  • Duration: TaskDuration (Tasks)
  • %
  • Completion: TaskPercentWorkCompleted (Tasks)
  • Resource: ResourceName (Resources)

Allan_Rocha_Gantt_chart_in_PowerBI_figure_6

Add some extra charts and slicers (an alternate way to do filtering that narrows the portion of the dataset shown in the other visualizations on the page).

And you’re done! You have now a Power BI Gantt chart ready to use!

Allan_Rocha_Gantt_chart_in_PowerBI_figure_7

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

Allan_Rocha_Gantt_chart_in_PowerBI_figure_8

Allan_Rocha_Gantt_chart_in_PowerBI_figure_9

To access your Power BI report, remember to enable custom visuals.

Allan_Rocha_Gantt_chart_in_PowerBI_figure_10

Allan_Rocha_Gantt_chart_in_PowerBI_figure_11

Enjoy the quick GIF below to see how cool your work is in real life!

Allan_Rocha_Gantt_chart_in_PowerBI_figure_12

A version of this article first appeared on Allan Rocha’s blog, ppm4all.

Is there a particular Power BI custom visual you like to use? Let the MPUG community know in comments below!


Related Content

Webinars (watch for free now!):
Back to the Future – When Gantt has Style

Articles:
Storytelling with Your Gantt Chart


Share This Post
12 Comments
  1. How did you make the ribbon slicer on the top of the gantt chart?

    Reply
  2. Hi Allan, where did your data set originate from for this? What’s the simplest way to get started? Could a person build it in excel and open in Power BI? What do you recommend?
    Thanks!

    Reply
  3. Where can I found the ribbon slicer on the top of the report? How is the data need to be prepared in order to accomplish the Gantt?

    Reply
  4. Hello,

    I am using this Gantt Chart in Power BI, I do see that that my graph is too small when I select Date Type as Month and too large with scroll bars when I select weeks. I need something like Bi-weekly, or I should be able to expand the gap between months in the axes to slightly expand the graph to fit my page. Also, I don’t want to see horizontal bars and I try to fit in one page to see entire graph, but not seeing any such option.

    I appreciate your response to use this visual more effectively.

    Thank,
    Ganesh

    Reply
  5. Could Tasks be shown on one single line ?
    When grouping task I’m expecting all blocks on one single line and only when expanding the group one task per line.
    Tasks could have a start date and end date but could also be miletsones (start date = end date).

    Reply
  6. Can this be sorted by Task Name?

    Reply
  7. Managed to get the Gantt working but have one problem, where a couple of the projects appear to extend way beyond their end dates, one stretches out to beyond the year 5000 !
    Would appreciate the options to :
    a) suppress the vertical grid lines, we have set the background to grey to hide the worst of them but the still appear over the top of other bars/milestones
    b) allow the overall bar to remain visible when expanded to show the milestones
    c) Legend colours to be selectable
    d) Include Baseline/Forecast dates for milestones to show when slippage (or not) is likely

    That said, I like what you’ve done so far and have implemented as part of our reporting pack.

    Reply
  8. You really forgot some important parts like formatting! I want to change the bar color based on status, not idea how to do that.

    Reply
  9. Hello Allan,
    Great work on presenting the steps to integrate Gantt charts.

    One feature I cannot find is the predecessors?
    Is there a way to visualize the dependencies between projects?

    Thanks

    Reply
  10. I want to customized hour in gantt chart , how can we change the hour accordingly in the timeline.

    Reply
  11. Which exact Gantt Chart add on is this?

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

9 + 1 =

Thanks for submitting your comment!
You must be logged in to comment.