Forum Discussion
Showing progress on multiple dates
Hi, I have 3 segements of a task with different dates and times. I have a bit of challenge here to show data on any graph which gives a meaningful insight and attractive visualisation.
For example, U-002's first segment starts on 28 March and ends on 29 March, 2nd Segment starts on 29 march and Ends on 30 March, 3rd Segement starts on 30 March and Ends on 30 March.
I want to show U-002's all 3 segments on with start date & time and segment end date & time in order to know how many segements were done a particular date.
Any help is much apprecaited.
| Project No | Activity ID | Activity Name | Unit ID | Unit No. | 1st Start Date | 1st Start Time | 1st End Date | 1st End Time | Hrs. Worked | Work Done (m) | 2nd Start Date | 2nd Start Time | 2nd End Date | 2nd End Time | Hrs. Worked2 | 3rd Start Date | 3rd Start Time | 3rd End Date | 3rd End Time | Hrs. Worked3 | Total Hrs. Worked (1st Date Time to End Date Time |
| 521 | 454 | Plumbing Works | 519 | U-002 | 28/03/2022 | 15:15 | 28/03/2022 | 23:30 | 8.25 | 3.82 | 29/03/2022 | 01:00 | 29/03/2022 | 04:00 | 3 | 30/03/2022 | 04:40 | 30/03/2022 | 19:50 | 15.17 | 4.58 |
| 521 | 454 | Plumbing Works | 511 | U-003 | 22/03/2022 | 05:50 | 22/03/2022 | 12:00 | 6.17 | 3.81 | 22/03/2022 | 14:00 | 22/03/2022 | 18:00 | 4 | 22/03/2022 | 00:10 | 22/03/2022 | 22:30 | 22.33 | 16.67 |
| 521 | 454 | Plumbing Works | 499 | U-009 | 09/03/2022 | 18:10 | 09/03/2022 | 20:30 | 2.33 | 3.59 | 09/03/2022 | 12:30 | 10/03/2022 | 04:00 | 15.5 | 10/03/2022 | 04:50 | 10/03/2022 | 09:55 | 5.08 | 15.75 |
| 521 | 454 | Plumbing Works | 506 | U-010 | 18/03/2022 | 04:20 | 19/03/2022 | 11:00 | 30.67 | 3.54 | 19/03/2022 | 12:00 | 19/03/2022 | 14:50 | 2.83 | 19/03/2022 | 15:30 | 19/03/2022 | 18:30 | 3 | 38.17 |
| 521 | 454 | Plumbing Works | 495 | U-011 | 05/03/2022 | 11:00 | 05/03/2022 | 15:20 | 4.33 | 3.63 | 05/03/2022 | 17:00 | 05/03/2022 | 21:00 | 4 | 05/03/2022 | 00:30 | 05/03/2022 | 23:50 | 23.33 | 12.83 |
| 521 | 454 | Plumbing Works | 502 | U-012 | 15/03/2022 | 18:00 | 16/03/2022 | 15:15 | 21.25 | 3.55 | 16/03/2022 | 16:00 | 16/03/2022 | 18:30 | 2.5 | 16/03/2022 | 19:05 | 16/03/2022 | 22:45 | 3.67 | 28.75 |
| 521 | 454 | Plumbing Works | 510 | U-014 | 20/03/2022 | 16:30 | 21/03/2022 | 02:30 | 10 | 3.55 | 21/03/2022 | 04:45 | 21/03/2022 | 07:45 | 3 | 21/03/2022 | 09:25 | 21/03/2022 | 12:05 | 2.67 | 19.58 |
| 521 | 454 | Plumbing Works | 505 | U-015 | 16/03/2022 | 18:00 | 17/03/2022 | 21:05 | 27.08 | 3.58 | 17/03/2022 | 04:00 | 18/03/2022 | 05:30 | 25.5 | 18/03/2022 | 06:00 | 18/03/2022 | 11:10 | 5.17 | 17.17 |
| 521 | 454 | Plumbing Works | 516 | U-016 | 26/03/2022 | 19:00 | 27/03/2022 | 06:00 | 11 | 3.56 | 21/03/2022 | 04:45 | 21/03/2022 | 07:45 | 3 | 22/03/2022 | 14:00 | 23/03/2022 | 18:45 | 4.75 | 23.75 |
| 521 | 454 | Plumbing Works | 508 | U-017 | 20/03/2022 | 11:30 | 20/03/2022 | 14:25 | 2.92 | 3.58 | 20/03/2022 | 17:00 | 20/03/2022 | 21:30 | 4.5 | 20/03/2022 | 00:00 | 20/03/2022 | 23:40 | 23.67 | 12.17 |
| 521 | 454 | Plumbing Works | 514 | U-018 | 23/03/2022 | 21:30 | 24/03/2022 | 13:30 | 16 | 3.55 | 24/03/2022 | 15:00 | 24/03/2022 | 18:00 | 3 | 24/03/2022 | 00:10 | 24/03/2022 | 23:30 | 23.33 | 26 |
| 521 | 454 | Plumbing Works | 509 | U-020 | 21/03/2022 | 09:00 | 22/03/2022 | 01:45 | 16.75 | 3.56 | 22/03/2022 | 03:00 | 22/03/2022 | 05:00 | 2 | 22/03/2022 | 06:30 | 22/03/2022 | 10:55 | 4.42 | 1.92 |
| 521 | 454 | Plumbing Works | 500 | U-021 | 10/03/2022 | 22:30 | 11/03/2022 | 01:45 | 3.25 | 3.63 | 11/03/2022 | 07:30 | 11/03/2022 | 11:00 | 3.5 | 11/03/2022 | 11:25 | 11/03/2022 | 23:45 | 12.33 | 1.25 |
| 521 | 454 | Plumbing Works | 507 | U-022 | 19/03/2022 | 16:30 | 20/03/2022 | 06:00 | 13.5 | 3.57 | 20/03/2022 | 07:30 | 20/03/2022 | 11:10 | 3.67 | 20/03/2022 | 01:20 | 20/03/2022 | 12:45 | 11.42 | 20.25 |
| 521 | 454 | Plumbing Works | 494 | U-023 | 03/03/2022 | 09:30 | 03/03/2022 | 13:41 | 4.18 | 3.56 | 03/03/2022 | 17:00 | 04/03/2022 | 19:00 | 2 | 04/03/2022 | 00:50 | 04/03/2022 | 22:50 | 22 | 13.33 |
| 521 | 454 | Plumbing Works | 501 | U-024 | 03/03/2022 | 09:30 | 03/03/2022 | 13:41 | 4.18 | 3.56 | 03/03/2022 | 17:00 | 04/03/2022 | 19:00 | 2 | 04/03/2022 | 00:50 | 04/03/2022 | 22:50 | 22 | 13.33 |
| 521 | 454 | Plumbing Works | 497 | U-025 | 03/03/2022 | 09:30 | 03/03/2022 | 13:41 | 4.18 | 3.56 | 03/03/2022 | 17:00 | 04/03/2022 | 19:00 | 2 | 04/03/2022 | 00:50 | 04/03/2022 | 22:50 | 22 | 13.33 |
| 521 | 454 | Plumbing Works | 504 | U-026 | 16/03/2022 | 21:43 | 17/03/2022 | 16:27 | 18.73 | 3.55 | 17/03/2022 | 17:30 | 17/03/2022 | 19:30 | 2 | 17/03/2022 | 00:30 | 17/03/2022 | 23:35 | 23.08 | 25.87 |
mohammadyousaf
I think best thing is to 1st unpivot the step columns to make it more suitable for further analysis. Look at what I created here (all in Power Query) and see if you can take it from here:
Showing progress on multiple dates 2022-05-08.pbixHi mohammadyousaf ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
mohammadyousaf
I think best thing is to 1st unpivot the step columns to make it more suitable for further analysis. Look at what I created here (all in Power Query) and see if you can take it from here:
Showing progress on multiple dates 2022-05-08.pbixHi mohammadyousaf ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SpartaBI , this helped me a lot and I am near to find a solution... I now want to plot this data on 24 Hours in Gantt chart... do you think if it is doable by DAX or I need to make changes to data?
This is because my data expands to endless scrolling gantt chart but in fact it is based on 24 hours shift each day.
Any assistance is much appreciated.Thanks.
