Forum Discussion
24 Hour Gantt Chart | How to approach?
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!
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.
2 Replies
- mahoneypat
Microsoft Employee
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
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.
