GANTT Chart multiple schedules in the same line

[RPAI2812]

Hi!

I run a project which there is a LOT of equipment that will go through 4 stages:

• Fabrication
• Tests
• Transportation
• Installation

 So I have the start date and end date of each of this stages for each equipment.

Equipment	Stage	StartDate	EndDate
Structure 1	Fabrication	01/01/22	20/01/22
Structure 1	Tests	25/01/22	28/01/22
Structure 1	Transportation	05/02/22	07/02/22
Structure 1	Installation	10/02/22	15/02/22
Structure 2	Fabrication	06/01/22	27/01/22
Structure 2	Tests	30/01/22	05/02/22
Structure 2	Transportation	10/02/22	16/02/22
Structure 2	Installation	19/02/22	28/02/22
...	...	...	...

Yes, there are some gaps in time between steps due to some intermediate steps that are not that relevant.

To get a good visualization of the project overall schedule, I wanted to display the data in a GANTT Chart.

From the MS Project schedule, I get the four stages of each equipment in different lines each of them, but in Power Bi I wanted something different... I wanted to have one line per equipment and each line would have the four stages represented in the same line... That is, it would be like I'd have four start dates and four end dates for the same line..

I tried to illustrate to make it clear like an AS IS (MS PROJECT) and a TO BE (PBI)

Is this even possible to be done?

My best regards

@moizsherwani @v-yanjiang-msft @amitchandak @SteveHailey @AlexisOlson 

[moizsherwani]

@RPAI2812 Thanks for tagging me, does the solution proposed by @v-luwang-msft work for you?

[v-luwang-msft · Accepted solution]

Hi @RPAI2812 ，

According to your description, since your x-axis is date, I think you can select timeline visual and then use the unpivot column function in the power query for the fields that need to be displayed in the same row. It should meet your needs. Refer to the following related solutions.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien