24 Hour Gantt Chart | 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!

[Anonymous · Accepted solution]

Hi @Anonymous ,

This visual in AppSource called  as Timeline allows you to create a Gnatt chart with hours/mins.

Or you can try to create a matrix according this post.

Best Regards,

Stephen Tao

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

[mahoneypat]

It is possible either with one of the custom Gantt visuals you can download, or you can turn a Matrix into a Gantt chart with the right DAX measure and some conditional formatting.  You will likely need a disconnected table with your Hour values to be used on the columns of the matrix to be used in your DAX measure to check if that hour is >= StartTime && <=EndTime.

Creating A Gantt Chart In Power BI Using Matrix | Enterprise DNA

Pat