timeline/gantt chart over a 24 hour period

[po]

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

[v-janeyg-msft · Accepted solution]

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)

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.

[po]

Hi,

Thanks for info and example.

Thanks