Forum Discussion
Need help with burndown chart
All - Thank You for your help. I am not sure where to start to build out a burndown chart.
In ADO, I have 4 fields in a user story with which to build a burndown:
- Title
- server count
- migration date
- Retirement date
>50% of the titles don't have migration and/or retirement date.
Every title will have a server count value.
Goal is to build a monthly burndown chart for the last 2 years, consolidating between migrating and retirement date and showing how many more servers are left to migrate/retire.
Sample data:
Title | Server Count | Migration date | Retirement date |
Title 1 | 2 | 02/20/2019 |
|
Title 2 | 1 |
|
|
Title 3 | 2 |
| 03/10/2020 |
Title 4 | 3 |
| 05/15/2022 |
Title 5 | 2 | 01/25/2022 |
|
What I would like to see is:
Feb 2019 - 10 Servers
…
Mar 2020 - 8 Servers
..
Jan 2022 - 6 Servers
May 2022 - 4 Servers
Is this doable in PowerBI? Any help is really appreciated. Thanks!
V.