Burndown Chart for Sprint Planning

[asawn]

Hello Community,

      I have to create a Burdown graph using Line chart for PI Planning. Our 1 PI is equal to 1 Quarter i.e. 3 months.

     Now, I have to show Planned vs Actual completion of Features in Current PI using Line Chart.

     Would really appreciate if anyone please help with DAX on how we can achieve that. Below is the data for your reference,

Feature_ID     PI       PI_Start_Date    PI_End_Date     Feature_Start_date    Feature_End_date     Feature_Plan_End_Date
111             Q1.24    01-15-2023      04-15-2023          01-17-2023              02-10-2023                      02-15-2023
123             Q1.24    01-15-2023      04-15-2023          02-13-2023              03-13-2023                      03-29-2023
14566         Q1.24    01-15-2023      04-15-2023          03-15-2023              04-10-2023                      04-15-2023

 Thanks in advance

[asawn]

Thank you so much for your reply @lbendlin , above is the outcome I am expecting. So 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. 

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

Thanks for your time.

[asawn]

@lbendlin  We can consider below data, apologies, we are moving to next quarter hence I took 2024 dates. Please consider below data for above expected output. Apologies for the confusion. Dates are now corrected

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

[lbendlin]

please check your sample data. Are you mixing up 2023 and 2024?

[lbendlin]

What would be the expected outcome based on your sample data?