Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi everyone,
I am a new user to Power Bi and I am hoping the community may be able to help me with my problem.
In Power Bi I want to create a dashboard that will contain a gantt view of my projects refecltive of all the different stages/phases within the lifecycle in one line across the time horizon.
My data table has the follwoing columns;
TaskID | TaskName | ParentTask | TaskStart | TaskEnd | RAG | Assignee |
1 | Project 1 | 01-Aug-23 | 27-May-24 | Green | joe Bloggs | |
2 | Project 2 | 01-Aug-23 | 27-May-24 | Green | joe Bloggs | |
9 | Project Charter | 1 | 31-Aug-23 | 26-Jun-24 | Green | joe Bloggs |
10 | Scope and Analysis | 1 | 30-Sep-23 | 26-Jul-24 | Green | joe Bloggs |
11 | Requirements | 1 | 30-Oct-23 | 25-Aug-24 | Green | joe Bloggs |
12 | Development | 1 | 29-Nov-23 | 24-Sep-24 | Green | joe Bloggs |
13 | Testing | 1 | 29-Dec-23 | 24-Oct-24 | Green | joe Bloggs |
14 | Implementation | 1 | 28-Jan-24 | 23-Nov-24 | Green | joe Bloggs |
15 | Project Charter | 2 | 31-Aug-23 | 26-Jun-24 | Green | joe Bloggs |
16 | Scope and Analysis | 2 | 30-Sep-23 | 26-Jul-24 | Green | joe Bloggs |
17 | Requirements | 2 | 30-Oct-23 | 25-Aug-24 | Green | joe Bloggs |
18 | Development | 2 | 29-Nov-23 | 24-Sep-24 | Green | joe Bloggs |
19 | Testing | 2 | 29-Dec-23 | 24-Oct-24 | Green | joe Bloggs |
I am using the PowerGannt chart visualisation which now looks like this
I would like there tow items on the left (Y axsis) Project 1 and Project 2 and all the different phases reflected on the x axis.
How should I go about this?
I have tried to incoorpate a heirachy between task id and parent task but this didnt change the end result.
Thank you in advance for your assistance on this.