Forum Discussion
Burn Down Chart for Tracking Project specific Milestones with fixed duration of days.
Hello folks,
I am struggling to find the right methodology to create Burn down chart for tracking Project Milestone. Below follows my scenario with some raw data:
| Milestone Name | Start date | End date | Status | Task Key | Summary | Original estimate | Time Spent | Remaining Estimate | Assignee |
| Development | 1.06.2023 | 14.07.2023 | To Do | ABC - 1111 | Sign-in page | fixed | fixed | fixed | a |
| Development | 1.06.2023 | 14.07.2023 | To Do | ABC - 1234 | Email Upload | fixed | fixed | fixed | b |
| Development | 1.06.2023 | 14.07.2023 | To Do | ABC - 1345 | dropdown filter | fixed | fixed | fixed | c |
| Development | 1.06.2023 | 14.07.2023 | Blocked | ABC - 1456 | back button | fixed | fixed | fixed | d |
| Development | 1.06.2023 | 14.07.2023 | In Progress | ABC - 1567 | reduce processing time | fixed | fixed | fixed | e |
| Development | 1.06.2023 | 14.07.2023 | In Progress | ABC - 1678 | account management | fixed | fixed | fixed |
Scope of work is based on start & end date.
The data is uploaded on daily basis into Power BI to track the progress of Development milestone.
Can someone help me to formulate the logic or provide the solution in .pbix file format?
Looking forward for your support.
Regards,
Mohit
2 Replies
mosarahit48 , need an example of find outcome.
But see if attached file or blogs below can help
Power BI: HR Analytics - Employees as on Date: https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs
The Solution gives a way to create relationships between to date tables which I created, unfortunately I was looking for a different solution based on the data which I shared on above Table.
If it is possible for you to provide me with any solution relating to it.
Thank you for your valuable feedback, I appreciate it.
