Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
veyron
Regular Visitor

Need help with burndown chart

‎02-21-2023 10:37 AM

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.

Labels:
Message 1 of 1
264 Views
0
0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

View All