How to Create a Gantt Chart in Power BI: Step-by-Step Guide

# How to Create a Gantt Chart in Power BI: Step-by-Step Guide

This guide explains how to build a Gantt chart in Power BI using the Microsoft Gantt custom visual. It walks through the required source data, importing and transforming in Power Query, adding the visual, mapping fields, and basic customization and troubleshooting.

What you need first

Prepare an Excel workbook with one row per task. At minimum include:

• Task (text)
• Start Date (date)
• End Date (date)

• Owner (text) — person responsible
• Completion (decimal) — progress as fraction or percentage

Format the range as a Table (Insert > Table) and give it a friendly name such as ProjectTasks. If your plan has repeated task names across projects, add a Project Name or Task ID to distinguish them.

Importing and checking data in Power BI

Open Power BI Desktop and use Home > Get data > Excel workbook. Select the table and click Transform data to open Power Query. In Power Query:

• Set Task and Owner to Text
• Set Start Date and End Date to Date
• Set Completion to Decimal Number

If dates appear reversed (day/month vs month/day), use Change Type > Using Locale to load dates correctly. Click Close & Apply when the types are correct.

Installing and adding the Microsoft Gantt visual

In the Visualizations pane click the three dots > Get more visuals. Search for "Gantt" and select the result by Microsoft Corporation, then click Add. If your organization restricts visuals, check My organization or ask your Power BI admin.

Place the Gantt visual on the canvas and size it wide enough to show your timeline (for example, a month view for September needs horizontal room).

Mapping fields and basic settings

Drag columns into the visual fields in this order to build the chart:

• Task → Task (labels displayed on the left)
• Start Date → Start Date (positions the start of each bar)
• End Date → End Date (positions the finish)
• Completion → Completion (shows progress inside the bar)
• Owner → Resource (assigns responsibility)

If your source uses Duration instead of End Date, the visual can accept that configuration depending on the visual's field options.

Useful chart behaviors and filters

• Completion shows different progress levels inside each task bar.
• Owner lets you identify who is responsible for each task.
• Add slicers for Owner or Project Name to filter the Gantt chart to a person or project.

Keep one row per task to avoid duplicate bars. If multiple projects share task names like "Testing," include a project identifier in the task label.

Troubleshooting common issues

• Missing visual: your account may not be allowed to install Microsoft visuals. Check the My organization gallery or ask your Power BI administrator.
• Date errors: verify locale and change type in Power Query. A displayed start date that's clearly wrong usually signals a locale mismatch (e.g., 04/09 versus 09/04).

Milestones and dependencies

Gantt visual supports displaying milestones and can show sequencing, but the exact capabilities depend on the visual version and fields it exposes. For milestone or dependency workflows, check the visual's documentation and publisher details before use.

Conclusion