Showing progress on multiple dates

[mohammadyousaf]

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

[SpartaBI · Accepted solution]

@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.pbix

Showcase Report – Contoso By SpartaBI



      

[mohammadyousaf]

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. 

@v-jianboli-msft 

[v-jianboli-msft · Accepted solution]

Hi @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.

[SpartaBI · Accepted solution]

@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.pbix

Showcase Report – Contoso By SpartaBI