Gantt chart display for team member schedule

[Anonymous]

Hi Team,

I am trying to create a visual which shows the schedule of team members for next 6 months. For e.g. Person A could be working on Project ABC for 5 working days a month and he again might be working on Project DEF for another 6 working days and remaining 9 working days on Project XYZ. How can i show his allocated hours across few projects for next 3 months ?

I am trying to use Gantt 2.2.3 but the person A is split across all the different projects he is working on. This is helping as i want to show a single line for each team member.

I have shown the data for Person A working on multiple projects over next 4 months.

Apologies for being all over the place

Thank  you

Chinmay 

[amitchandak · Accepted solution]

@Anonymous , At an initial look, it seems like a matrix with background color using conditional formatting using the measure.

There are a few options in terms of Gantt chart visual not sure that will work for you

https://appsource.microsoft.com/en/product/power-bi-visuals/WA104380765?tab=Overview
https://www.mpug.com/articles/how-to-create-an-amazing-gantt-chart-in-power-bi/
https://blog.pragmaticworks.com/power-bi-custom-visuals-as-timeline

[Greg_Deckler]

@Anonymous Not 100% on the issue but I don't think I've ever used that visualization. Maybe a different gantt chart like:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Text-Gantt-Chart/m-p/253466#M57