Uptime Downtime chart by production line, different colors for each downtime reason on the same line

[owenbolick]

Hello everyone, I have been tasked with building a line chart for uptime and downtime for production lines. I am struggling to find a chart that supports what I want to do. Essentially, it the y-axis will be each production line name. The time frame needs to be from 7 am to 7 am of the next day. The line also needs to show different color segments for each downtime reason. For example, 7-9am 'breakfast break' would be a yellow segment, then 9-11am would show green for that segment on uptime, so on and so forth. Does anyone know of a chart that can support this?

[v-hjannapu]

Hi @owenbolick ,

Thank you for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank @rohit1991 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

Just follow the steps in the attached official document, and you'll be able to solve the issue.
Building a Gantt Chart using Power BI

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Harshitha.
Community Support Team.

[rohit1991]

Hi @owenbolick ,

What you're looking to build is essentially a Gantt-style timeline chart where each production line occupies a row on the y-axis, and the x-axis represents time from 7 AM to 7 AM the next day. Each downtime or uptime period is shown as a colored segment based on the reason. While standard Power BI visuals like line or bar charts don’t support this out of the box, you can achieve it using a custom Gantt chart visual from the Power BI marketplace or by using a stacked bar chart with time duration calculations.

For the custom Gantt chart, structure your data with fields like Line Name, Start Time, End Time, and Reason, then assign colors based on the reason. Alternatively, tools like Deneb or Plotly custom visuals give you full control over visuals and color logic. These allow you to tailor the layout to exactly match your needs, including showing time-based colored segments for each production line. Let me know if you'd like help setting up the data structure for this.

[owenbolick]

Hi @rohit1991 @v-hjannapu ,

Thank you for your replies. Here are some of the issues I am still running into, and I am starting to think that Power BI does not support what I am trying to do:

1. All of my end times are defaulting to 24 hours after the start time. It is forcing me to summarize my ends times, and I have attempted to make a multitude of measures to dodge this with no luck.

2. This is more of a question than an issue, but the goal of this is that once I collapse the parent, all of the segments combine into a multicolored line for the 24 hours with the different reasons. Is this possible with this chart?

I have tried playing around with Charticulator but it was very confusing to me. I am about to look into Deneb and give that a try. Thank you all again!

[v-hjannapu · Accepted solution]

Hi @owenbolick ,
Thanks for reaching out and sharing the Query.

On end times defaulting to 24 hours after the start time:
This usually happens when Power BI treats the datetime difference incorrectly or applies summarization. Try creating a calculated column or measure to explicitly calculate duration (e.g., in minutes) using DAX. Also, double-check that your start and end time fields are in datetime format, and that visuals aren’t summarizing them by default.

For combining segments into a multicolored line on collapse:
Power BI’s native visuals don’t support multicolored segments within a single line. However, custom visuals like Deneb (Vega-Lite) can achieve this behavior. Alternatively, you might consider a stacked bar or Gantt-style chart to represent segmented time ranges with colors per reason.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Harshitha.
Community Support Team.

[v-hjannapu]

Hi @owenbolick,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Harshitha.
Community Support Team.

[v-hjannapu]

Hi @owenbolick,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Best Regards,
Harshitha.
Community Support Team.

[v-hjannapu]

Hi @owenbolick,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Best Regards,
Harshitha.
Community Support Team.