Reply
k0ater
Regular Visitor

create Jobs Duration Time Series Graph

Hi!
I have dataset that looks like this:

 

Job NameStartEndDuration (days)
JOB2412.07.2018 03:00:5312.07.2018 03:30:530,020833333
JOB2312.07.2018 02:37:3612.07.2018 02:38:090,000381944
JOB2212.07.2018 02:37:3612.07.2018 02:38:040,000324074
JOB2112.07.2018 02:37:1312.07.2018 02:37:141,15741E-05

..........

Start and End have DateTime type. Duration is simply End minus Start. 
Some Jobs overlap in time.

I am trying to visualize Jobs Flow using Stacked Bar Chart. Ideally (reproduced in Excel) it should look like this:

 

Jobs overlap Graph, Excel

Please help to create similar Graph in Power BI Desktop.

 

In Excel I set 'Start' and 'Duration' to Legend and then 'No fill' Start. In Power BI Desktop only one variable possible to add to the Legend.

1 ACCEPTED SOLUTION
luxpbi
Helper V
Helper V

Hi k0ater,

 

Add this custom visual to your report: 

Captura.PNG

 

You just have to put the start date and the end date.

The visual is very powerful, so I let the configuration of the visual to you. 

But you should be able to see somenthing like this: 

Captura1.PNG

or this:

Captura2.PNG

If my answer is what you where looking for, please mark it as accepted. Like this, others can benefit from my answer too.

 

Regards

View solution in original post

2 REPLIES 2
luxpbi
Helper V
Helper V

Hi k0ater,

 

Add this custom visual to your report: 

Captura.PNG

 

You just have to put the start date and the end date.

The visual is very powerful, so I let the configuration of the visual to you. 

But you should be able to see somenthing like this: 

Captura1.PNG

or this:

Captura2.PNG

If my answer is what you where looking for, please mark it as accepted. Like this, others can benefit from my answer too.

 

Regards

Thanks! Thats exactly what I need

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)