Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MJT03
Frequent Visitor

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:

MJT03_0-1678824304641.png

 

Thank you!

 

4 REPLIES 4
MG23NL
Frequent Visitor

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/#articleT...

 

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:

MultipleMilestonesTable.png

MultipleMilestones.png

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 support@novasilva.com 

poorlyjoker
New Member

Hi, 
I am facing the same roadblock. Did you find a solution?

Thanks and Regards!

MG23NL
Frequent Visitor

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.powerga... 

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. PowerGantt by Nova Silva need license to use it right? Can we use microsoft Gantt chart to create multiple milestone in 1 row? If can, can you show me how? Thank you in advance!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.