24 Hour Gantt Chart UTC | How to approach?

[Anonymous]

Hey folks,

Quick question here. So I have a dataset with 20 employees from around the world. For simplicity sake, fields include: Name, Start time working hours, end time working hours. I want to be able to create a static 24 hour gantt chart view showing when our employees are working within a universal 24 hour window.

I'm not too sure if this is possible, but if anyone has any guidance they could provide here, I'd really appreciate any help that I can get. Thank you!

[v-yetao1-msft]

Hi @Anonymous 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

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

[Anonymous]

Hey folks,

Quick question here. So I have a dataset with 20 employees from around the world. For simplicity sake, fields include: Name, Start time working hours, end time working hours. I want to be able to create a static 24 hour gantt chart view showing when our employees are working within a universal 24 hour window.

I'm not too sure if this is possible, but if anyone has any guidance they could provide here, I'd really appreciate any help that I can get. Thank you!

[parry2k]

@Anonymous there are many Gantt chart visual available on the app store, did you try any one of those?

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hey all -

I have a employee dim table with name, start time, end time, and UTC time zone.

We have folks working in the states, west coast, central, eastern, India, Romania, etc.

I want to create a 24 hour x axis Gantt Chart showing when all employees work based on the start and end time fields. How do I configure everything to 24 hour UTC time so I can create this Gantt chart should resource allocation throughout 24 hours? Do I use power query or Dax/power BI to configure this? Do the Gantt visuals allow a 24 hour view?

If anyone has any advice, input, or resources, please provide.

Thank you

[v-yetao1-msft]

Hi @Anonymous 

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

Original data :

(1)Then create a column to count the duration between the two time .

Duration = DATEDIFF('Table'[Start time working hours],'Table'[end time working hours],MINUTE)

(2)Add a Gantt chart , put 'Table'[Name] in Task, 'Table'[Start time working hours] in Start Date , 'Table'[Duration] in Duration .

(3)Change the format settings for the Gantt chart .We use MINUTE as unit in calculated column ,so we should change the unit in General ,and change the date type to Day in Date Type .

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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