Forum Discussion
How to create gantt chart from Excel schedule
Hi, I'm new to PBI.
I am managing project A, B, and C in using Excel WBS below.
Each project has several tasks, and tasks have dependencies and need to be done one by one in each project.
| Project | Task | PlannedDate | ActualDate |
| A | A-1 | 2024/4/8 | |
| A | A-2 | 2024/4/9 | |
| A | A-3 | 2024/4/10 | |
| B | B-1 | 2024/4/8 | |
| B | B-2 | 2024/4/9 | |
| B | B-3 | 2024/4/10 | |
| C | C-1 | 2024/4/8 | |
| C | C-2 | 2024/4/9 | |
| C | C-3 | 2024/4/10 |
|
Is there a way to show Gantt chart for each project from the excel above?
We need to visualize the progress of each project and which one is critical..
Thanks a lot in advance.
Hi lulufk
There are many options to create gantts with power bi .
Take a look at the linked tutorials, I choose the ones that in my opinion are simple and do the job 🙂https://www.youtube.com/watch?v=fgCWlXLu-c4
https://www.youtube.com/watch?v=8pbFvBMT9L8
https://www.youtube.com/watch?v=QugkBqc-jIs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi lulufk
There are many options to create gantts with power bi .
Take a look at the linked tutorials, I choose the ones that in my opinion are simple and do the job 🙂https://www.youtube.com/watch?v=fgCWlXLu-c4
https://www.youtube.com/watch?v=8pbFvBMT9L8
https://www.youtube.com/watch?v=QugkBqc-jIs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly