Is it possible to show the delayed progress in PowerBI Gantt Chart?

[yr112]

I have different projects with different stages with planned starting and end dates in Gantt Chart. I would like to show the delay progress if the actual date is beyond the planned one. Is it possible to do so? Task Completion seems only max. 100%. Thank you.

[Anonymous]

Hi @yr112 ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.

[Anonymous]

Hi @yr112 ,
I wanted to follow up on our previous suggestions regarding the issue you are facing. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. 
Thank you

[Anonymous]

Hi @yr112 ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Thank you.

[Anonymous · Accepted solution]

Hi @yr112 ,
Thank you @bhanu_gautam  for the helpful repsonse!

Here’s a complete and clear step-by-step guide :

• Create a delay measure using below query
     DelayDays = DATEDIFF('Table'[PlannedEndDate], 'Table'[ActualEndDate], DAY)
• Create a calculated column to your table using following query:
      DelayStatus =
      IF('Table'[Actual End] > 'Table'[Planned End], "Delayed", "On Time")
  
  
  
• Plot a Gantt visual :
  

  Task: 'Table'[Task]

  Start Date: 'Table'[Planned Start]

  End Date: 'Table'[Planned End] 

  Legend: 'Table'[DelayStatus]

  % Completion: 'Table'[Completion]

• Refer the attached file for reference
  
  

If the solution resolved your query,consider accepting it as solution.

Regards,
Pallavi.

[bhanu_gautam]

@yr112 , You can create a new measure to check delay

   DelayDays =

   DATEDIFF('Table'[PlannedEndDate], 'Table'[ActualEndDate], DAY)

Use conditional formatting to highlight tasks that are delayed. You can apply this to the Gantt Chart bars or create a separate visual to show the delay status.

While task completion typically maxes out at 100%, you can visually represent delays by extending the Gantt bars or using color coding to indicate tasks that have exceeded their planned duration.

Select the Gantt Chart visual.
Go to the Format pane.
Find the Data Colors section.
Add rules to change the color based on the delay measure.