Forum Discussion

RPAI2812's avatar
RPAI2812
Icon for Helper I rankHelper I
4 years ago
Solved

GANTT Chart multiple schedules in the same line

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.

EquipmentStageStartDateEndDate
Structure 1Fabrication01/01/2220/01/22
Structure 1Tests25/01/2228/01/22
Structure 1Transportation05/02/2207/02/22
Structure 1Installation10/02/2215/02/22
Structure 2Fabrication06/01/2227/01/22
Structure 2Tests30/01/2205/02/22
Structure 2Transportation10/02/2216/02/22
Structure 2Installation19/02/2228/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 

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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