Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!