Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mohammadyousaf
Resolver II
Resolver II

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 NoActivity IDActivity NameUnit IDUnit No.1st Start Date1st Start Time1st End Date1st End TimeHrs. WorkedWork Done (m)2nd Start Date2nd Start Time2nd End Date2nd End TimeHrs. Worked23rd Start Date3rd Start Time3rd End Date3rd End TimeHrs. Worked3Total Hrs. Worked (1st Date Time to End Date Time
521454Plumbing Works519U-00228/03/202215:1528/03/202223:308.253.8229/03/202201:0029/03/202204:00330/03/202204:4030/03/202219:5015.174.58
521454Plumbing Works511U-00322/03/202205:5022/03/202212:006.173.8122/03/202214:0022/03/202218:00422/03/202200:1022/03/202222:3022.3316.67
521454Plumbing Works499U-00909/03/202218:1009/03/202220:302.333.5909/03/202212:3010/03/202204:0015.510/03/202204:5010/03/202209:555.0815.75
521454Plumbing Works506U-01018/03/202204:2019/03/202211:0030.673.5419/03/202212:0019/03/202214:502.8319/03/202215:3019/03/202218:30338.17
521454Plumbing Works495U-01105/03/202211:0005/03/202215:204.333.6305/03/202217:0005/03/202221:00405/03/202200:3005/03/202223:5023.3312.83
521454Plumbing Works502U-01215/03/202218:0016/03/202215:1521.253.5516/03/202216:0016/03/202218:302.516/03/202219:0516/03/202222:453.6728.75
521454Plumbing Works510U-01420/03/202216:3021/03/202202:30103.5521/03/202204:4521/03/202207:45321/03/202209:2521/03/202212:052.6719.58
521454Plumbing Works505U-01516/03/202218:0017/03/202221:0527.083.5817/03/202204:0018/03/202205:3025.518/03/202206:0018/03/202211:105.1717.17
521454Plumbing Works516U-01626/03/202219:0027/03/202206:00113.5621/03/202204:4521/03/202207:45322/03/202214:0023/03/202218:454.7523.75
521454Plumbing Works508U-01720/03/202211:3020/03/202214:252.923.5820/03/202217:0020/03/202221:304.520/03/202200:0020/03/202223:4023.6712.17
521454Plumbing Works514U-01823/03/202221:3024/03/202213:30163.5524/03/202215:0024/03/202218:00324/03/202200:1024/03/202223:3023.3326
521454Plumbing Works509U-02021/03/202209:0022/03/202201:4516.753.5622/03/202203:0022/03/202205:00222/03/202206:3022/03/202210:554.421.92
521454Plumbing Works500U-02110/03/202222:3011/03/202201:453.253.6311/03/202207:3011/03/202211:003.511/03/202211:2511/03/202223:4512.331.25
521454Plumbing Works507U-02219/03/202216:3020/03/202206:0013.53.5720/03/202207:3020/03/202211:103.6720/03/202201:2020/03/202212:4511.4220.25
521454Plumbing Works494U-02303/03/202209:3003/03/202213:414.183.5603/03/202217:0004/03/202219:00204/03/202200:5004/03/202222:502213.33
521454Plumbing Works501U-02403/03/202209:3003/03/202213:414.183.5603/03/202217:0004/03/202219:00204/03/202200:5004/03/202222:502213.33
521454Plumbing Works497U-02503/03/202209:3003/03/202213:414.183.5603/03/202217:0004/03/202219:00204/03/202200:5004/03/202222:502213.33
521454Plumbing Works504U-02616/03/202221:4317/03/202216:2718.733.5517/03/202217:3017/03/202219:30217/03/202200:3017/03/202223:3523.0825.87
2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

@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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Showcase Report – Contoso By SpartaBI

Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

View solution in original post

v-jianboli-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
mohammadyousaf
Resolver II
Resolver II

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
Community Support
Community Support

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
Community Champion
Community Champion

@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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Showcase Report – Contoso By SpartaBI

Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.