power bi gantt chart from excel

Power BI Gantt Chart from Excel: Your Step-by-Step Guide

By John Williams
AD

Boosting your data visualization game with Power BI? You're in the right place! Today, we're diving into creating interactive Gantt charts from your Excel data, a game-changer for project management and tracking tasks. Let's get started!

Before we dive in, let's ensure you're well-equipped. You'll need Power BI Desktop, an Excel file with your data, and a basic understanding of both tools. Ready? Let's roll up our sleeves and create a visually stunning Gantt chart!

Preparing Your Excel Data

First things first, let's get your Excel data in order. For a Gantt chart, you'll need four key columns: Task, Start Date, End Date, and Duration. Other columns for dependencies, milestones, or progress can also be included.

AD
Power BI Gantt Chart
Power BI Gantt Chart
Selecting the Right Gantt Chart Visual for Power BI
Selecting the Right Gantt Chart Visual for Power BI
Power BI Gantt Chart
Power BI Gantt Chart

Let's say we have an Excel file named 'ProjectData.xlsx' with tasks, their start and end dates, and durations. Our data looks like this:

Task Start Date End Date Duration
Task 1 2022-01-01 2022-01-07 7

Connecting Excel to Power BI

With your data ready, open Power BI Desktop. Click on 'Get Data' and choose 'Excel'. Navigate to your 'ProjectData.xlsx' file, select the sheet with your data, and click 'Load'.

3 Easy Ways To Make a Gantt Chart (+ Free Excel Template)
3 Easy Ways To Make a Gantt Chart (+ Free Excel Template)
an excel spreadsheet showing project schedules and other items in the workflow
an excel spreadsheet showing project schedules and other items in the workflow
Download Project Management Templates for Excel Today
Download Project Management Templates for Excel Today

Your Excel data is now in Power BI. Let's transform it into a stunning Gantt chart!

Creating the Gantt Chart

In Power BI, go to 'Report' > 'Create a new report'. From the left-hand side 'Visualizations' pane, drag and drop the 'Line chart' to the canvas. This will serve as the base for our Gantt chart.

AD

Now, let's configure the data fields for our chart:

an info sheet with different types of electrical devices and their corresponding functions in the diagram
an info sheet with different types of electrical devices and their corresponding functions in the diagram
a project plan is shown in the office calendar tool box, with multiple tasks displayed on it
a project plan is shown in the office calendar tool box, with multiple tasks displayed on it
Free Gantt Chart Template for Excel
Free Gantt Chart Template for Excel
a screenshot of a project plan with multiple columns and numbers on each column, along with the following steps
a screenshot of a project plan with multiple columns and numbers on each column, along with the following steps
Gantt Chart Excel
Gantt Chart Excel
How to Create a Gantt Chart in Excel (Free Template) and Instructions | Planio
How to Create a Gantt Chart in Excel (Free Template) and Instructions | Planio
  • Yue the 'Task' field to 'Axis'
  • Drag and drop 'Duration' to 'Values'
  • Format: Line chart type, and enable 'Mark as dual axis'
  • To adjust axis settings: 'X-axis' set to 'Date'.

The chart should now be shaping up nicely, showing tasks with their durations along the date axis. But it's not yet a Gantt chart. Let's fix this!

To make it a proper Gantt chart, we need to add waterfall bars for the start and end dates of each task. Right-click on 'Duration' in 'Values', and select 'duplicate'.

AD

For the first duplicate, change the field to 'Start Date' and make the color transparent. For the second duplicate, change the field to 'End Date', and make it a different color. Adjust the order of these fields to ensure they display correctly.

Gantt chart infographic | Premium Vector
Gantt chart infographic | Premium Vector

And there you have it! A fully functional Gantt chart created from your Excel data in Power BI. Your project stakeholders will love you for this!

Styling and Customizing Your Gantt Chart

To make your Gantt chart truly stand out, let's add some stylish elements and customizations.

AD

You can adjust colors, fonts, and borders in the 'Visualizations' pane. For interactive features, you can add tooltips, drillthrough filters, or sorting and filtering options.

Adding Milestones, Dependencies, and Task Progress

To enhance your Gantt chart, you can add milestones, dependencies between tasks, or a progress column to track task completion. Each of these features requires specific formatting and data setup, but they can greatly enrich your chart.

Let's say you have a 'Milestone' column in your Excel data. To visualize it, create a new 'Category' field called 'Is Milestone', with options 'Yes' (for milestones) and 'No' (for regular tasks). You can then add a 'Mark' visual to the report, using 'Is Milestone' to display milestone symbols or icons.

With these customizations, your Power BI Gantt chart is now a powerful tool for managing and presenting project data.

Updating Your Gantt Chart with Fresh Data

As your project progresses, make sure to keep your Gantt chart up-to-date. Simply refresh the Excel data in Power BI, and your Gantt chart will update automatically!

Refreshing data can be done manually or set to a schedule using the 'Data refresh' options in Power BI.

And there you have it, folks! Your transformation from Excel data to interactive, Power BI Gantt charts complete. Now go forth and inspire your project stakeholders with these stunning visuals!

AD