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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
PhineasT
Helper I
Helper I

Display Dates with Wait Times by Slicer

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)

PhineasT_0-1683120783234.png

TicketNumberTicketDateInTimeOutTimeWaitTime
S156/3/20196:58 AM7:08 AM0:10:39
S166/3/20196:58 AM7:12 AM0:13:22
S236/3/20196:58 AM7:09 AM0:10:57
S176/3/20196:59 AM  
S246/3/20196:59 AM8:16 AM1:16:44
S186/3/20197:00 AM  
S256/3/20197:01 AM7:29 AM0:28:33
S196/3/20197:01 AM  
S266/3/20197:01 AM7:10 AM0:08:55

 

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors