Forum Discussion
Display waiting time (Duration)
Hello!
I would like to ask for help on how I can visualize duration in Power BI.
What I would like to see, in minutes and seconds format, is the wait times broken down by month.
I have this data available in excel,
For example, the average wait time for the month 01.2023 was 5 minutes 12 seconds (00:05:12) ect.
If I want to display it in a bar chart, it returns the number of rows in the table.
Thanks for your help in advance!
1 Reply
Please see this article. Keep your duration as a decimal (in days), so you can do aggregations (sum, avg) and use it in visuals, but then display it how you want (in tooltips, measure-driven data labels).
Calculate and Format Durations in DAX – Hoosier BI
Pat
