Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
jb_graphic
Frequent Visitor

How to show queue time in a visual.

‎01-18-2024 01:11 PM

Hello everyone,

I'm relatively new to Power BI and could use some guidance. I might not be framing my questions or providing sample data in the best way, so please let me know if adjustments are needed.

My current project involves mimicking the concept of "on-hold" calls in a call center and displaying this information visually for better insights. Specifically, I want to create a visual that illustrates how long a job stays in the queue and whether there are multiple jobs in the queue.

Any advice, examples, or pointers in the right direction would be greatly appreciated!

Here is a sample of my data.

CreateDateCreateTimeStartDateStartTimeEndDateEndTimeQueueTimeRunTimeStatusUser Name
Friday, July 7, 20234:49:26 PMFriday, July 7, 20234:50:32 PMFriday, July 7, 20235:26:12 PM135Successuser3
Saturday, July 8, 202312:12:27 AMSaturday, July 8, 202312:14:29 AMSaturday, July 8, 202312:35:51 AM221Successuser3
Tuesday, July 11, 20232:13:52 PMTuesday, July 11, 20232:29:00 PMTuesday, July 11, 20232:55:34 PM1526Successuser4
Wednesday, July 12, 20238:13:41 PMWednesday, July 12, 20238:15:09 PMWednesday, July 12, 20238:37:51 PM122Successuser3
Monday, July 17, 20235:00:35 PMMonday, July 17, 20235:48:02 PMMonday, July 17, 20235:50:18 PM472Successuser4
Monday, July 17, 20237:42:36 PMMonday, July 17, 20239:55:33 PMMonday, July 17, 20239:55:53 PM1320Successuser3
Monday, July 17, 20238:51:14 PMMonday, July 17, 202311:14:56 PMMonday, July 17, 202311:16:18 PM1431Successuser5
Tuesday, July 18, 20233:07:15 AMTuesday, July 18, 20239:44:05 PMTuesday, July 18, 20239:44:25 PM11160Successuser3
Wednesday, July 19, 20234:26:03 PMThursday, July 20, 20238:55:44 PMThursday, July 20, 20238:57:02 PM17091Successuser5
Thursday, July 20, 20233:06:38 AMFriday, July 21, 20233:44:27 PMFriday, July 21, 20235:40:08 PM2197115Successuser2
Friday, July 28, 20234:40:39 PMSunday, July 30, 20235:35:18 AMSunday, July 30, 20236:00:03 AM221424Successuser3
Friday, July 28, 20234:42:30 PMSunday, July 30, 20236:00:17 AMSunday, July 30, 20236:38:07 AM223737Successuser3
Tuesday, August 1, 20239:23:07 PMTuesday, August 1, 20239:25:25 PMTuesday, August 1, 20239:43:35 PM218Successuser6
Tuesday, August 1, 20239:24:43 PMTuesday, August 1, 20239:43:50 PMTuesday, August 1, 202310:02:06 PM1918Successuser6
Wednesday, August 2, 20232:56:01 AMWednesday, August 2, 20232:58:09 AMWednesday, August 2, 20232:58:29 AM20Successuser1
Wednesday, August 2, 20238:49:08 AMWednesday, August 2, 20238:51:16 AMWednesday, August 2, 20238:51:36 AM20Successuser1
Wednesday, August 2, 20239:10:48 AMWednesday, August 2, 20239:12:57 AMThursday, August 3, 20231:56:56 AM21003Failuser1
Wednesday, August 2, 20232:27:07 PMThursday, August 3, 20231:57:39 AMThursday, August 3, 20232:22:51 AM69025Successuser6
Wednesday, August 2, 20234:40:46 PMThursday, August 3, 20232:22:55 AMWednesday, August 16, 202311:48:02 AM58219285Successuser5
Wednesday, August 16, 202312:56:26 PMWednesday, August 16, 202312:58:38 PMWednesday, August 16, 202312:58:59 PM20Successuser4
Wednesday, August 16, 20231:03:41 PMWednesday, August 16, 20231:05:56 PMWednesday, August 16, 20231:35:37 PM229Successuser4
Wednesday, August 16, 20232:55:46 PMWednesday, August 16, 20232:57:59 PMWednesday, August 16, 20235:02:40 PM2124Successuser9

 

I would like a visual that looks something like this.

jb_graphic_0-1705611871626.png

 

and this

jb_graphic_1-1705611886887.png

 

Thanks
Jason

Labels:
Message 1 of 2
340 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

‎01-18-2024 10:34 PM

Hi @jb_graphic ,

 

I made some attempts and you can check the results as follows, you can change it yourself in specific cases:

vtianyichmsft_0-1705645991032.png

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

How to show queue time in a visual.pbix
Message 2 of 2
292 Views
1 REPLY 1
Anonymous
Not applicable

‎01-18-2024 10:34 PM

Hi @jb_graphic ,

 

I made some attempts and you can check the results as follows, you can change it yourself in specific cases:

vtianyichmsft_0-1705645991032.png

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

How to show queue time in a visual.pbix
Message 2 of 2
293 Views

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All