Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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!
Solved! Go to Solution.
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!
Thanks 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.
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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.