cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
po
Post Prodigy
Post Prodigy

timeline/gantt chart over a 24 hour period

Hi,

 

Have following table with events which happen over a 24 hour period and wanted to xepict these as chart on timeline/gantt chart

events can go over midnight as well and soem have dependecies.

 

Anyone a sample .pbix doing similar?

 

How can this be best achieved?

 

 

task, start_time, end_time, dependency

prepare , 01/01/1900 17:00:00, 01/01/1900 18:15:00,,

load_master, 01/01/1900:23:00 , 02/01/1900 05:00,prepare

load_task1, 01/01/1900 19:00, 01/01/1900 22:00:00, prepare

load_task2, 01/01/1900 23:00:00, 01/01/1900, 23:30:00, load_task1

 

Thanks

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @po 

 

According to your description, I made a sample file, you need to calculate the duration first.

Like this:

Column = DATEDIFF('Table'[start_time],'Table'[end_time],MINUTE)

 

v-janeyg-msft_0-1621240467199.png

Reference:How to Create a Gantt Chart in Power BI (Fast and Easy) (spreadsheeto.com)

If you still need help, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-janeyg-msft
Community Support
Community Support

Hi, @po 

 

According to your description, I made a sample file, you need to calculate the duration first.

Like this:

Column = DATEDIFF('Table'[start_time],'Table'[end_time],MINUTE)

 

v-janeyg-msft_0-1621240467199.png

Reference:How to Create a Gantt Chart in Power BI (Fast and Easy) (spreadsheeto.com)

If you still need help, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi,

 

Thanks for info and example.

 

Thanks

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors