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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Abhi15
Regular Visitor

Need urgent help in burndown chart for Feature completion in Sprint PI

Hello Community,
  

IMG_5693.JPG

    

Here I am Showing Projected Completion rate Vs Planned Target Date. Let me make it more simple with below sample data


Feature_ID     PI         Start_Date          Projected_End_Date       Target_Date
111             Q1.24     01-15-2024           03-07-2024                 04-15-2024
123             Q1.24     01-15-2024           03-21-2024                 04-21-2024
14566         Q1.24     01-15-2024           03-28-2024                 04-29-2024

 

Here, for "Projected Completion Rate" we have Start_Date and End_Date. For "Planned Target Rate" we have Target Date.

 

Now, with all this data I have to generate Burndown chart just like above for current quarter (It should take the current quarter automatically). So basically, we have to see feature completed with respect to Planned Target Rate.

 

For example, on 9th Sep there were 5 features and then on 18 October there are 4 features.

 

I am expected to get the outcome as in above snap

 

Could someone please help me with this on how we can implement this? Please let me know if more data or more info is needed.


Thanks in advance
@PBICommunity  @Greg_Deckler  @Anonymous @Anonymous @v-weiyan1-msft 

     

2 REPLIES 2
Abhi15
Regular Visitor

@Greg_Deckler , Thank you so much for this DAX cookbook. But the code is related to remaining hours. And here I have to show feature completion counts. Could you please give any idea on how can I achieve it.

Greg_Deckler
Community Champion
Community Champion

@Abhi15 I did a burndown chart in DAX Cookbook. Can't remember the chapter or recipe and not in my home office or I could check. The PBIX files are available here: PacktPublishing/DAX-Cookbook: DAX Cookbook, Published by Packt (github.com)



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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