Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Seeking assistance creating Cards that display 'Wait Times'.
The unique output desired would include a slicer-type action that allows user to chose a day on the calendar by specifc date and/or day or week. Also, a slider that allows user to chose an hour segment of a specific day and/or day of week - providing the following output in different 'Cards' -
1. User should be able to select an hourly time range for a given day and Power BI should display the
'average wait time per hour' for the hour chosen hour.
2. User should be able to select a given week and Power BI should display the day and time in which the
'average wait time' was the shortest amount of time during that chosen week, showing the date and time
of shortest wait, and the length of that wait time in hh:nn:ss (hours, mins, secs).
Is this possible?
Test data attached.
Column Type
Date Date
InTime Custom (h:mm)
OutTime Custom (h:mm)
WaitTime Custome (h:mm:ss)
TicketNumber | TicketDate | InTime | OutTime | WaitTime |
S15 | 6/3/2019 | 6:58 AM | 7:08 AM | 0:10:39 |
S16 | 6/3/2019 | 6:58 AM | 7:12 AM | 0:13:22 |
S23 | 6/3/2019 | 6:58 AM | 7:09 AM | 0:10:57 |
S17 | 6/3/2019 | 6:59 AM | ||
S24 | 6/3/2019 | 6:59 AM | 8:16 AM | 1:16:44 |
S18 | 6/3/2019 | 7:00 AM | ||
S25 | 6/3/2019 | 7:01 AM | 7:29 AM | 0:28:33 |
S19 | 6/3/2019 | 7:01 AM | ||
S26 | 6/3/2019 | 7:01 AM | 7:10 AM | 0:08:55 |