topic Re: Visualizing report run times across the day in Custom Visuals Development Discussion

Visualizing report run times across the day

HuJa26 — Thu, 26 Mar 2026 18:53:53 GMT

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!

Re: Visualizing report run times across the day

lbendlin — Fri, 27 Mar 2026 20:00:00 GMT

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/1447523

Re: Visualizing report run times across the day

HuJa26 — Sun, 29 Mar 2026 23:44:07 GMT

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.

Re: Visualizing report run times across the day

lbendlin — Mon, 30 Mar 2026 01:42:26 GMT

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.

Re: Visualizing report run times across the day

HuJa26 — Mon, 30 Mar 2026 12:20:55 GMT

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!