Forum Discussion
Create a 3-periods Gannt chart
I need to create a 3-period Gannt chart (or any other vizual could work if you could suggest) looking this way
Periods are identified by colors. Here's the legend
My database is an Excel file looking this way:
| Projects | Director | Phase 1-2 / Start Date | Phase 1-2 / Finish Date | Phase 1-2 Duration (Days) | Phase3 / Start Date | Phase3 / Finish Date | Phase 3 Duration (Days) | Phase 4-5 / Start Date | Phase 4-5 / Finish Date | Phase 4-5 Duration (Days) | Baseline % Completion |
| Project 1 | Director Name | 2022-05-01 | 2022-09-01 | 123 | 2022-09-02 | 2022-10-31 | 59 | 2022-11-01 | 2022-11-15 | 14 | 86% |
| Project 2 | Director Name | 2021-04-01 | 2022-09-30 | 547 | 2022-10-01 | 2022-11-01 | 31 | 2022-11-02 | 2022-11-30 | 28 | 93% |
2 Replies
Hi novakvic ,
I'm a little confused about your needs, Could you please explain them further?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin YuI need to reproduce the Gannt chart I have in Excel in Power BI.
That's a list of projects. They are evolving by 3 phazes (1-2; 3 & 4-5). For Excel Gannt they are sorted by the oldest to appear first (it being the column Phase 4-5 / Finish Date). I need to produce the report showing
the phases by colors;
the percentage of completion;
the name of the director.
I have videos to create a one phase Gannt chart, but didn't manage to reproduce the report with all 3 periods, showing as well the percentage of completion and the name of director.
Hope that's clear now, if no, please let me know and thank you so much for help!
