Power BI Gantt Chart: the complete guide
A Power BI Gantt chart is a horizontal timeline visual that plots tasks, projects or promotions as bars across a date axis. Power BI has no native Gantt visual, so you add one from Microsoft AppSource, either the free Microsoft Gantt visual or a certified custom visual with fiscal calendars, milestones, planned-vs-actual baselines and large-dataset support.
What is a Gantt chart in Power BI?
A Gantt chart shows a schedule as horizontal bars on a time axis: each row is a task, campaign or work item, and the bar spans its start and end date. In Power BI it answers "what runs when, and does it overlap?" in a single, filterable view, something a native table or matrix cannot draw. Use one for project portfolios, programme roadmaps, maintenance windows, content calendars and FMCG trade-promotion planning.
How to add a Gantt chart to Power BI
- Get a Gantt visual from AppSource: open the Visualizations pane, choose "Get more visuals", and search AppSource for "Gantt".
- Bind your task/category to the row well and your start and end dates to the date wells; add optional % complete, group, milestone or colour fields.
- Format the timeline: set the zoom (day / week / month / quarter / year), the calendar (standard or fiscal 4-4-5), colours, labels and the today line.
Power BI has no built-in Gantt visual, and the native line, bar or matrix visuals cannot render a true date-range timeline. A dedicated Gantt visual is the only way.
The main Power BI Gantt visuals compared
- Microsoft Gantt: free, certified, best for basic task timelines at no cost.
- MAQ Software Gantt: free on AppSource, certified, best for resource and milestone views.
- xViz Gantt: freemium (Pro paid), certified, best for enterprise and baselines.
- Inforiver: paid suite, best for broad analytics and writeback.
- Promo Gantt (Vibecode Studio): free tier plus per-country Pro, certified, best for fiscal-calendar timeline planning at 10,000+ rows.
What sets Promo Gantt apart
- Overlap detection and auto-stacking: overlapping activities in the same group are placed on separate rows, and M / O / D markers flag multi-brand, overlap/clash and duplicate records, so timing conflicts are visible at a glance.
- Up to 3 grouping levels: group rows by up to three levels (for example customer, brand, then sub-brand) with per-level sorting (source, alphabetical or by start date).
- Expandable hierarchy (tree): show the top level as collapsible parent rows, each with a roll-up bar and aggregated roll-up progress; click to expand children, or expand and collapse all with one button.
- Typed milestones: deadline, gate, go-live and more, each with its own colour and shape.
- % progress and planned vs actual: a percentage-complete fill and duration-in-days label per task, plus an optional planned baseline bar beneath each actual bar.
- Conditional formatting and heat-map colour: colour bars by rule (fx) or as a numeric heat-map, with up to three colour dimensions and colour-blind-safe pattern fills.
- Up to three extra row columns beside the timeline (budget, owner, status) with number formatting.
- Multi-zoom and fiscal calendars: from a whole multi-year portfolio down to day and hour level, on standard or fiscal 4-4-5 / 4-5-4 / 13-period calendars, with Working Days and a year-over-year Ghost Mode overlay.
- Search plus legend and row-label cross-filtering that drives the report page, near-instant at 10,000+ rows.
Built for FMCG but mapped to any domain: the field wells use FMCG names (Promo, Customer, Brand, ATL), but a "promo" can be a project, work order, booking or campaign, and a lane a programme, asset, vehicle or channel. A second overlay track (ATL in FMCG) adds any related workstream, media campaigns, milestones or dependencies, alongside the main timeline, and event-week overlays highlight holidays, gates, shutdown windows or any key dates.
Where Promo Gantt fits
Promo Gantt is our Microsoft-certified Power BI Gantt visual, a planning and project/portfolio Gantt in one. Built for FMCG trade-promotion planning, where fiscal calendars, overlapping promotions and thousands of rows are the norm, and equally at home on project portfolios, programme roadmaps, maintenance plans and content calendars. Free to use with basic features and a 14-day Pro trial, in five languages (English, Dutch, German, French, Spanish), with all data kept inside Power BI and near-instant interactions at 10,000+ rows. Pro licensing is per country.
Frequently asked questions
Does Power BI have a built-in Gantt chart?
No. Power BI has no native Gantt visual. You add one from Microsoft AppSource, either the free Microsoft Gantt visual or a certified custom visual such as Promo Gantt.
How do I add a Gantt chart in Power BI?
Open the Visualizations pane, choose "Get more visuals", search AppSource for "Gantt", add the visual, then bind your task, start date and end date fields.
Is there a free Power BI Gantt chart?
Yes. Microsoft ships a free Gantt visual, and Promo Gantt has a free tier that is a genuinely useful single-level Gantt with colour-blind patterns and in-bar dates.
What is the best Power BI Gantt chart for large datasets?
Look for a visual that fetches more than the 5,000-row default and stays smooth. Promo Gantt handles 10,000+ rows at 60fps with near-instant group-by and zoom switching.
Can a Power BI Gantt chart show milestones and planned vs actual?
The native visuals cannot, but certain custom visuals can. Promo Gantt supports typed milestone markers and an optional planned baseline bar beneath each actual bar.
Do Power BI Gantt custom visuals work in Power BI Service?
Certified visuals do, and also render in subscription emails and PowerPoint export. Promo Gantt works in Power BI Desktop, Service and Embedded on one license key.