Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

24 Hour Gantt Chart

Hey folks - Apologies for repetitive posts, but I'd figure I give this one more try. 

 

I am trying to create a gantt chart that shows a 24 Hour View of when people are working in a 24 hour UTC day. My main issue is trying to make the X Axis look half decent. I want it to clearly state that the axis starts at 0:00:00 to 24:00:00 either hour by hour or every 2 hours.

 

My axis keeps looking like this: 

 

Does anyone have any idea how to do this easily? I even had to use the TODAY function on my time fields so I'd actually be able to visualize some of this stuff.

Need Help

3 Replies

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    Hello there Anonymous ! Where does the hours field come from? A date dimension with continuous data? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      So in the Employee Dimension Table, here are the fields: Consultant Name, Role, Time Zone, Start time UTC, End Time UTC. Both Start time and end time are like so: "3:30:00 AM" in this format.

       

      I then made 2 calculated columns that look like this:

      Today Start Date and Time = TODAY() + dimConsultant[Start Time UTC]
      Today End Date and Time = TODAY() + dimConsultant[End Time UTC]
       

       

       So now this is what my Power BI Desktop screen looks like when I use a custom Gantt Visual, with the fields in:
       

       

       
      • goncalogeraldes's avatar
        goncalogeraldes
        Super User
        4 years ago

        Anonymous it's probably a stupid question but have you set your date type to "hour"?