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
ERing
Helper V
Helper V

How can I create a drill through/drill down from date to hourly data?

I have data like in the table below and I need a way for the user to right click on a bar chart with daily date and drill through/drill down to hourly data.

 

I'm interested in seeing two metrics. 

1. Count of calls

2. Avgerage call duration by hour


I'm not sure where to get started on this. Any help is greatly appreciated.

 

IDCall Start TimeDateAgentDuration (seconds)Purchase Amount
110/2/22 10:06 AM10/2/2022Sam61105
210/3/22 11:40 AM10/3/2022Rob96408
310/2/22 1:49 PM10/2/2022Rob133498
410/1/22 2:25 PM10/1/2022Sam141256
510/1/22 2:47 PM10/1/2022Ann61371
610/2/22 12:40 PM10/2/2022Rob188127
710/3/22 2:31 PM10/3/2022Ann100206
810/2/22 2:34 PM10/2/2022Rob147438
910/1/22 10:20 AM10/1/2022Ann13084
1010/1/22 10:53 AM10/1/2022Ann14497
1110/1/22 10:36 AM10/1/2022Sam59106
1210/1/22 11:52 AM10/1/2022Rob115229
1310/2/22 2:29 PM10/2/2022Ann12573
1410/1/22 12:46 PM10/1/2022Rob32315
1510/2/22 12:01 PM10/2/2022Rob146475
1610/3/22 12:00 PM10/3/2022Rob187362
1710/1/22 2:41 PM10/1/2022Sam6854
1810/1/22 10:20 AM10/1/2022Rob120397
1910/3/22 1:36 PM10/3/2022Sam74270
2010/1/22 2:12 PM10/1/2022Ann190418
2110/1/22 2:51 PM10/1/2022Ann3174
2210/2/22 12:33 PM10/2/2022Ann123161
2310/2/22 11:44 AM10/2/2022Ann6630
2410/3/22 2:04 PM10/3/2022Ann88224
2510/1/22 12:48 PM10/1/2022Ann98233
2610/3/22 12:12 PM10/3/2022Rob55142
2710/3/22 11:03 AM10/3/2022Sam132367
2810/2/22 11:02 AM10/2/2022Ann11915
2910/3/22 2:55 PM10/3/2022Ann166380
3010/1/22 1:00 PM10/1/2022Rob186167
3110/1/22 12:13 PM10/1/2022Sam9539
3210/2/22 1:13 PM10/2/2022Sam1332
3310/2/22 12:03 PM10/2/2022Rob125259
3410/3/22 2:44 PM10/3/2022Sam52377
3510/2/22 12:38 PM10/2/2022Ann64434
3610/2/22 11:58 AM10/2/2022Ann35199
3710/3/22 1:04 PM10/3/2022Rob34274
3810/3/22 11:27 AM10/3/2022Ann900
3910/2/22 12:51 PM10/2/2022Sam196466
4010/1/22 2:13 PM10/1/2022Ann17726
4110/1/22 11:41 AM10/1/2022Rob4867
4210/1/22 2:26 PM10/1/2022Rob176268
4310/2/22 11:52 AM10/2/2022Ann165246
4410/1/22 11:49 AM10/1/2022Ann112491
4510/3/22 12:07 PM10/3/2022Sam34445
4610/2/22 11:49 AM10/2/2022Ann96477
4710/1/22 10:03 AM10/1/2022Rob157461
4810/3/22 1:24 PM10/3/2022Rob172161
4910/2/22 12:16 PM10/2/2022Rob136327
5010/2/22 11:26 AM10/2/2022Ann14278



2 REPLIES 2
CoreyP
Solution Sage
Solution Sage

This short video should be helpful: https://www.youtube.com/watch?v=8DFih8ccMV0

Thanks @CoreyP 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

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.