Visual to show Committed Date vs Completion Date

[Anonymous]

Hi All,

Need to show committed date vs completion date visual representation for all the items that are Completed on time/ completed after delay. Below is the sample data.

Item #	Status	Committed Date	Completion Date
1	Completed on Time	6/10/2022	5/5/2022
2	Completed after delay	7/15/2022	12/1/2022
3	Completed on Time	1/25/2023	12/5/2022
4	Completed on Time	8/2/2022	7/7/2022
5	Completed after delay	5/5/2021	6/6/2022

Not sure which visual to use to represent them. Please help.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could try to use pie chart for represent them:

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , See if the use of a single date table and userelationship can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970