Forum Discussion
Visualizing report run times across the day
I'm probably just not using the right search terms here, but hoping someone can point me to some resources.
We have a log of reports being run throughout the day, providing us with the following data points:
- report name
- date start
- time start
- date end
- time end
- elapsed seconds
And I've gotten all of that parsed out into a table well enough with relationship to a date table and whatnot.
What I'm hoping to achieve something like below, where we can visualize each report's elapsed time across a period of time (24 hours usually).
PBI is trying to aggregate the data, because that's usually the point. But since I'm trying to do each report as a separate item on the graph, I guess akin to a Gantt chart, but I'm not getting very far. Closest thing I've found are gantt charts across days of the month, not across minutes/seconds in the day. Anyone have any ideas about where I could learn about something like this?
Hope I explained that well enough, thanks in advance to everyone that looks at this!
Here you go
Start and End need to be complete DateTime fields.
The Vega Lite code is very basic - you can change it as needed.
4 Replies
This is easily achieved with a Deneb Bar chart with secondary x axis (for the end date).
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thanks for replying lbendlin
The data looks like this:
ReportName RunSeconds DateStart TimeStart Report 1 672 2/6/2026 12:06:33 AM Report 2 684 2/6/2026 12:17:45 AM Report 3 699 2/6/2026 12:29:09 AM Report 4 715 2/6/2026 01:00:58 AM Report 5 682 2/6/2026 02:04:40 AM Report 6 12630 2/6/2026 02:50:27 AM Report 7 934 2/6/2026 06:20:59 AM And mapping it out with my advanced MS Paint skills:
Alternative to RunSeconds field, there are also DateEnd and TimeEnd fields.
Here you go
Start and End need to be complete DateTime fields.
The Vega Lite code is very basic - you can change it as needed.
Thank you for pointing me at Deneb! Exactly what I was looking for, and now I have a new tool to play with as well!
