Plotting actual and projected on Gantt chart- milestones

[uwish7]

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.

[Sahir_Maharaj]

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.