Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
102 | |
68 | |
46 | |
37 | |
37 |