Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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.
@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
please check your sample data. Are you mixing up 2023 and 2024?
What would be the expected outcome based on your sample data?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
18 | |
17 |
User | Count |
---|---|
36 | |
22 | |
19 | |
18 | |
12 |