Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I run a project which there is a LOT of equipment that will go through 4 stages:
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
Solved! Go to 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
@RPAI2812 Thanks for tagging me, does the solution proposed by @v-luwang-msft work for you?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |