Pipeline runtime Visualization

[ParkerOH]

I am trying to make a visualization in PBI that shows various pipelines start times, end times, and runtimes (duration). My data set has 3 days of data, I'd like to have the dates on the x-axis, time of day by hour on the y-axis, and runtimes spanning from the start time to the end times of those y-axis time periods. Do you know what the best visualization would be? Google and AI say stacked bar charts or Gantt charts yet those don't quite fit, summing or counting my durations instead of showing them. Stacked bar charts with overlayed line charts do the same as well, counting either the y-axis or x-axis values when they need to be listed as is. 

[v-pnaroju-msft]

Hi ParkerOH,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi ParkerOH,

We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi ParkerOH,

Thank you for the update. Kindly keep us informed of any developments.

Please continue to use the Microsoft Fabric community forum for further questions.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi ParkerOH,

Thank you for your inquiry on the Microsoft Fabric Community Forum.

Based on my understanding, Power BI’s native visuals like bar/column/line/combo aggregate durations and do not support ranged spans on the Y-axis. Consequently, they cannot display a pipeline run as a vertical time‑of‑day window from Start to End. This limitation is the reason stacked bars or combo charts end up summing or counting values instead of rendering the actual start‑to‑end runtime on the Y‑axis.

Please consider the following approach, which may help resolve the issue:

1. Since native visuals aggregate durations and do not support Y‑axis start or end spans, use a custom visual such as Deneb or Charticulator to render vertical time‑of‑day windows per date from Start to End.

If you would like native visuals to support vertical time‑of‑day spans using Y or Y2 axes, kindly submit this requirement to the Ideas forum via the provided link:Fabric Ideas - Microsoft Fabric Community

We hope the information above helps to resolve your issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

[ParkerOH]

Thank you for this response. I will look into the custom visuals you have given and let you know if they work!