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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mohammadyousaf
Resolver I
Resolver I

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 I
Resolver I

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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