Forum Discussion
Gant chart with multiple phases
It is likely impossible to achieve a 1:1 identical view to your Excel file using standard or custom Gantt visuals in Power BI.
In addition to the visualizations already suggested, I prefer creating a Gantt chart manually using the Matrix visual. In my opinion, this is the most flexible method for handling complex requirements like multiple date types (Plan, Delay, Real) on a single row.
Here are some excellent tutorials on this approach:
https://www.youtube.com/watch?v=QugkBqc-jIs
https://www.youtube.com/watch?v=8pbFvBMT9L8
https://www.youtube.com/watch?v=SO4mk1H94OA
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Most Gantt visuals (including Maq’s) are built around a single start/end per task row. If you duplicate the task 3 times (Plan/Delay/Real), the visual treats them as 3 separate tasks, so they appear on separate lines. So you need to restructure your table or maybe data and use single rows. Oruse a visual that supports multiple bars per task:
“Gantt Chart (by xViz)” (paid) – supports baseline/actual patterns
- “Deneb” (custom Vega-Lite) – fully flexible if you’re OK building it
Most Gantt visuals (including Maq’s) are built around a single start/end per task row. If you duplicate the task 3 times (Plan/Delay/Real), the visual treats them as 3 separate tasks, so they appear on separate lines. So you need to restructure your table or maybe data and use single rows. Oruse a visual that supports multiple bars per task:
“Gantt Chart (by xViz)” (paid) – supports baseline/actual patterns
- “Deneb” (custom Vega-Lite) – fully flexible if you’re OK building it