Forum Discussion

heejinyune's avatar
heejinyune
Frequent Visitor
3 years ago

How to show time durations using Gantt Chart

Hello Community! 

 

I'm new in Power BI 🙂 

I'd like to create Gantt Chart to show the model's different running duration(time) within a day. 

For example, my data table is like this:

Unique idModel NameImplement ReadyStage
a123Model A00:03:3007:22:1102:11:23
a124Model B01:00:2208:43:1101:33:21
a125model A00:02:2200:11:4000:09:02

 

I labelled model Name column to different colour. But once i tried to visualize this using Gantt Chart, can't visualise multiple

time duration for each unique id.. is there any way to present this data using Gantt Chart? Thank you so much! 

2 Replies

  • Hi heejinyune ,

     

    It works fine in my sied. Maybe I misunderstood? 

     

    If I misunderstood, can you please share more details to help us clarify your scenario?

    Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

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

  • heejinyune's avatar
    heejinyune
    Frequent Visitor

    Hi Jianbo 🙂

     

    Appologies wrong description.. 

    I want to show all steps duration. I inserted more details table in here. 

    For example, I want to show time duration of Pre implement, implement, stage, compile, system Route, system Generate within a day. As you can see the table, model has unique id and different log date.. is there any way to show all the duration with different log dates with Gantt chart?

    Thank you so much your help!! 

     

    Best regards,

    Heejin