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
rajdivate
Frequent Visitor

Gantt Chart Visuals to show Plan Vs Actuals Visual

Hi,

 

I am looking to visualise gantt chart where the actual start date is different from the plan date. Most of the custom visuals which i explored has the % of completion from the plan date, but does not provide details on the actual start date.

 

Is there any way to show Plan, Actuals and completion % for each task catagory in Gantt chart visual? Thanks for help !

7 REPLIES 7
amitchandak
Super User
Super User

@rajdivate , I used matrix once for project plan

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Thank You Amit Chandak sir for your quick response. I am basically looking to create similar visual as pasted below, where i should be able to filter - Plan, Actuals, % completion and overlap between Plan and Actuals (both).

 

 

rajdivate_0-1646842263391.png

rajdivate_1-1646842428250.png

 

rajdivate_3-1646842477164.png

 

Did you ever get this visual This is Exactly what I am looking for.

Did you ever get this visual This is Exactly what I am looking for.

Did you ever get this visual This is Exactly what I am looking for.

Hi @rajdivate ,

Please review the links which have the same requirement as yours, hope they can help you resolve your problem.

Create A Gantt Chart In Power BI With A Matrix Visual

yingyinr_1-1647929510578.png

GANTT chart visuals in Power BI

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank You !

 

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.