Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
veyron
Regular Visitor

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.

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.