Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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:

 

image.png

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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