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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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

Anonymous
Not applicable

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors