Preparing Your Project Data Ready for the Microsoft Gantt Visual in Power BI

The Microsoft Gantt Chart visual is a handy way to present project timelines in Power BI, but it does rely on your data being set up in a very particular way. A couple of small adjustments can make a big difference to how clearly your tasks and milestones appear on the chart.

This guide walks through the key steps for preparing your schedule data so the Microsoft Gantt visual displays everything cleanly and in the right order.

Getting Milestones Right

The Microsoft Gantt visual has a very simple rule when it comes to milestones:
All non-milestone tasks must have a blank value in the Milestone column.

Many scheduling tools export milestone fields as Boolean - Yes/No, True/False, or similar. Unfortunately, this visual doesn’t interpret these values and causes a known issue where all tasks appear similar to milestones.

To ensure milestones display correctly:

  • Add a value only for true milestones.
  • Leave the Milestone column blank for all standard tasks.

This small adjustment prevents every task from being flagged as a milestone and keeps your Gantt chart accurate.

See below an example of the data:

Excel Project Data highlighted to show milestone column with "Yes" value.

Sorting Tasks Using WBS

By default, the Microsoft Gantt visual sorts tasks by Finish Date. While that might seem reasonable, it often results in summary tasks appearing after their child tasks, which makes the project structure look out of order.

See example below:

Microsoft Gantt Chart Visual image showing an issue with sorting.

To sort tasks correctly:

  • Go to Table View.
  • Select the Task Name column.
  • In Column Tools, choose Sort by Column and select WBS.
Power BI Table View of Project schedule data showing how to sort the columns for preparing data for the Gantt Chart. Showing task name is selected than sorted by WBS
  • In the Gantt visual, set the Sort axis to Task Name and choose Sort ascending.
Microsoft Gantt Chart Power BI Visual image showing how to sort the content in the visual.
This ensures your summary tasks appear first, followed by their child tasks, preserving the natural structure of your project plan as shown in the image above.

Why These Steps Matter

The Microsoft Gantt Chart visual works best when project data is prepared for the visual. Getting your milestone fields right and sorting tasks using WBS ensures the chart displays your timeline in a clear, structured way that reflects the actual shape of your project.

By preparing your data with these simple rules:

  • Milestones appear exactly how they should
  • Tasks don't appear as milestones and  follow the correct hierarchy
  • The visual becomes a great high-level visual representation of your schedule

These small adjustments help the visual behave consistently, giving you a tidy and reliable project timeline in Power BI.

Back to blog

Leave a comment

Please note, comments need to be approved before they are published.