Forum Discussion

ctrlaldelight's avatar
ctrlaldelight
Frequent Visitor
7 months ago
Solved

Gant chart with multiple phases

Hello PowerBI community,
I am using PowerBI to transform this Excel file into PowerBI so that I have the same view in the Gantt chart.

 

 

Here in Excel, I can only manage one project per file. The idea was to switch to PowerBI to make it easier to create filters and so on.

I am using GANT CHART by Maq Software.

This is my database in Excel:

Project Start ProjectEnd ProjectFaseManager TesteTypeStartEnd
Project 101/01/202631/12/2026Receção de LayoutManager TestePlan17/11/202524/11/2025
Project 101/01/202631/12/2026Receção de LayoutManager TesteDelay18/11/202626/11/2026
Project 101/01/202631/12/2026Receção de LayoutManager TesteReal18/11/202619/11/2026
Project 101/01/202631/12/2026Receção do Projeto de ExecuçãoManager TestePlan13/01/202620/01/2026
Project 101/01/202631/12/2026Receção do Projeto de ExecuçãoManager TesteDelay13/01/202620/01/2026
Project 101/01/202631/12/2026Receção do Projeto de ExecuçãoManager TesteReal14/01/202626/01/2026
Project 201/01/202617/02/2026Receção de LayoutManager TestePlan17/11/202524/11/2025
Project 201/01/202617/02/2026Receção de LayoutManager TesteDelay18/11/202526/11/2025
Project 201/01/202617/02/2026Receção de LayoutManager TesteReal19/11/202525/11/2025
Project 201/01/202617/02/2026Divulgação de projeto SACE/ITEDManager TestePlan01/12/202515/12/2025
Project 201/01/202617/02/2026Divulgação de projeto SACE/ITEDManager TesteDelay03/12/202518/12/2025
Project 201/01/202617/02/2026Divulgação de projeto SACE/ITEDManager TesteReal02/12/202516/12/2025
Project 201/01/202617/02/2026Receção do Projeto de ExecuçãoManager TestePlan13/01/202620/01/2026

 

I replicated the lines of each task (Faser) so that I could compare the three types (Plan, Delay, and Real). I am not sure if I am designing my data structure correctly, but I am unable to replicate the Gantt chart I have in Excel for Power BI, i.e., the three types on the same task line:

 

Someone have one solution for this?

Thank you for your amazing help!

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    7 months ago

    Hi ctrlaldelight 

     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

  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    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

     

4 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    7 months ago

    Hi ctrlaldelight 

     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

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    7 months ago

    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

     

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    7 months ago

    Hi ctrlaldelight ,
    Thanks for reaching out to Microsoft Fabric Community.

    Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
    Thank you.