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
sirj993
New Member

Resource busy times over a day

Hi

 

I'm trying to build a chart that shows what procedures are taking up a resource's time throughout a single day. Kind of a timeline, but for a day. Procedures are composed out of steps. In the best case the result would look something like this:

sirj993_0-1697470652165.png

I've tried a number of timeline and gantt visualizations, but they all seem to be focused on days and are quite rigid in terms of bending em for my needs.

Is there a way to build a visualization like this? It needs to be precise to the second of utilization.

Below is some sample data for a day in case it's needed

 

SequenceDateProcNameProcStartProcEndProcDurationStepNameStepStartStepEndStepDuration
101.01.2023Proc18:11:058:29:100:18:05Step18:11:058:11:070:00:02
101.01.2023Proc18:11:058:29:100:18:05Step28:11:168:11:460:00:30
101.01.2023Proc18:11:058:29:100:18:05Step18:12:388:12:400:00:02
101.01.2023Proc18:11:058:29:100:18:05Step38:12:468:12:530:00:07
101.01.2023Proc18:11:058:29:100:18:05Step48:13:028:15:090:02:07
101.01.2023Proc18:11:058:29:100:18:05Step18:15:248:15:260:00:02
101.01.2023Proc18:11:058:29:100:18:05Step38:15:318:15:400:00:09
101.01.2023Proc18:11:058:29:100:18:05Step38:15:558:16:020:00:07
101.01.2023Proc18:11:058:29:100:18:05Step58:16:118:16:330:00:22
101.01.2023Proc18:11:058:29:100:18:05Step68:16:518:17:100:00:19
101.01.2023Proc18:11:058:29:100:18:05Step78:17:158:19:220:02:07
101.01.2023Proc18:11:058:29:100:18:05Step88:19:288:23:260:03:58
101.01.2023Proc18:11:058:29:100:18:05Step38:23:368:23:430:00:07
101.01.2023Proc18:11:058:29:100:18:05Step98:23:588:27:120:03:14
101.01.2023Proc18:11:058:29:100:18:05Step108:27:178:29:100:01:53
201.01.2023Proc28:53:349:08:400:15:06Step28:53:348:53:450:00:11
201.01.2023Proc28:53:349:08:400:15:06Step18:54:588:55:030:00:05
201.01.2023Proc28:53:349:08:400:15:06Step38:55:088:55:190:00:11
201.01.2023Proc28:53:349:08:400:15:06Step118:55:268:57:080:01:42
201.01.2023Proc28:53:349:08:400:15:06Step128:57:289:01:230:03:55
201.01.2023Proc28:53:349:08:400:15:06Step139:01:289:02:200:00:52
201.01.2023Proc28:53:349:08:400:15:06Step149:02:319:04:310:02:00
201.01.2023Proc28:53:349:08:400:15:06Step159:04:489:05:330:00:45
201.01.2023Proc28:53:349:08:400:15:06Step169:05:389:08:400:03:02
301.01.2023Proc29:29:239:49:580:20:35Step29:29:239:29:340:00:11
301.01.2023Proc29:29:239:49:580:20:35Step19:30:499:30:510:00:02
301.01.2023Proc29:29:239:49:580:20:35Step39:30:579:31:060:00:09
301.01.2023Proc29:29:239:49:580:20:35Step119:31:139:33:070:01:54
301.01.2023Proc29:29:239:49:580:20:35Step129:33:229:37:460:04:24
301.01.2023Proc29:29:239:49:580:20:35Step179:37:509:38:010:00:11
301.01.2023Proc29:29:239:49:580:20:35Step139:38:079:39:080:01:01
301.01.2023Proc29:29:239:49:580:20:35Step149:39:139:41:590:02:46
301.01.2023Proc29:29:239:49:580:20:35Step159:42:159:43:070:00:52
301.01.2023Proc29:29:239:49:580:20:35Step169:43:129:46:200:03:08
301.01.2023Proc29:29:239:49:580:20:35Step189:46:259:49:580:03:33

 

Thanks!

 

1 REPLY 1
sirj993
New Member

I think I've messed up with sample data, so here is a link to an excel file

Book10.xlsx

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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