Forum Discussion
Gantt Chart with Multiple Tasks on a Single Row
Hi all -
Looking for a visual in a Gantt-style chart.
My needs revolve around staffing - I have employees that work on reviewing products, broken up by category. There are multiple reviews happening on staggered timelines year-round, with busy durations and calm durations. I am trying to see all reviews in a gantt view with the durations of craziness and calm identified on one row, all against each other, so I can strategically assign my employees so that the busy durations do not overlap.
I am having trouble having multiple start/end dates appear on one row. If I have Task 1 starting in January and ending in March, and I would like to format that time frame as "red" for busy and then immediately following, Task 2 which begins when Task 1 ends and goes through April as "green" formatting to indicate calm.
Any recommendations on how to use multiple start/end dates on the same row, so that I can keep dates on the X Axis? I'm being forced to either pick one task or use durations only, and neither are useful without the other.
This is my end goal:
Thank you!
4 Replies
Hi,
You can have a look at the PowerGantt by Nova Silva, it supports baselines, multiple hierarchies, milestones and multiples items/tasks on a single row.
You can find it in the AppSource https://appsource.microsoft.com/en-us/product/power-bi-visuals/novasilvagroupbv1626174611009.powerganttchart?exp=kyyw&tab=Overview
Check the Knowledge Base to find examples https://visuals.novasilva.com/knowledge-base/kb-power-gantt-chart/introduction-power-gantt/
PowerGantt review https://youtu.be/SFN_CWHnF4Y
Regards, Marta
Hi,
I am facing the same roadblock. Did you find a solution?
Thanks and Regards!Hi,
The PowerGantt Chart by Nova Silva needs a license. You can create multiple milestones in a row.
In our Knowledge Base we have an article with example on how to achieve this. See https://visuals.novasilva.com/knowledge-base/kb-power-gantt-chart/introduction-power-gantt/#articleTOC_4
In your dataset you need to have a column with the Milestone dates and add the milestones as additional rows with the same ItemID. Like this:
The screenshots above are from our demobook available for download in the Microsoft AppSource (Click Download Sample button).
If you have any other questions about this or any other functionality of the PowerGantt Chart, do not hesitate to post it here or contact us at [email protected]
