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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
uwish7
New Member

Plotting actual and projected on Gantt chart- milestones

Hello for PowerBi Gantt 2.2.0 chart is it possible to add actual and project start and end dates?  I want to show the actual date and projected date are not the same.  Thanks for your help.

1 REPLY 1
Sahir_Maharaj
Super User
Super User

Hello @uwish7,

 

You can achieve this using custom visuals or workarounds:

 

1. There are various custom Gantt visuals available in the Power BI marketplace. Some might offer additional flexibility compared to the default visual. The xViz Gantt might be a good one to try.

2. One way to visualize actual vs. projected in the absence of a direct Gantt feature is using the stacked bar chart:

  • Use your task or project phase as the Axis.
  • Use the start date (either actual or projected) as the start point for the bars.
  • For values, you can use the duration for both actual and projected. This would effectively show two bars for each task.

3. As a last resort, you can use two Gantt charts side by side, one for actual dates and one for projected dates. This is not ideal as it can take up more space and might not be as intuitive.

 

Should you require my further assistance, please do not hesitate to reach out to me.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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