Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need help with understanding how to get a counts based on a date range Sample PBI file with required visualization. I have a table with some issues(id), duedate and fixversion(Includes PI name. One PI has 6 sprints in it). And another table with PI schedule and another table with Sprint schedule and there is a1:* relationship from PI_Schedule to issues(fixversion) and likewise from PI schedule to sprint schedule. What i need is count of id under each PI and when i drill down to sprint based on due date of issue i would like the count to be divided among the sprints.
But i dont understand how to accomplish this relationship between due date and the sprint start date, end date.
Thanks for the support in advance
Solved! Go to Solution.
Hi,
Download the PBI file from here.
Hope this helps.
Hi @axy5093
Based on my understanding,
count of id under each PI:
uPI_1 19
uPI_2 0
uPI_3 0
uPI_4 0
uPI_5 0
uPI_6 0
i drill down to sprint based on due date of issue
the hierarchy should be
SampleExporteddata[duedate]->Sprint Schedule[Sprint No]
the count to be divided among the sprints
How does this formula calculate?
Best Regards
Maggie
Right so when i drill down into uPI_1, instead of getting individual values for each sprint adding up to 19 i get 19 for all the sprints.
Any workarounds/ suggestions will be helpful!
Thanks,
Aishwarya
Hi,
Download the PBI file from here.
Hope this helps.
Thank you @Ashish_Mathur This is very helpful. My understanding from your solution is that for date comparisons we will need continuous dates. Please correct me if am wrong.
Regards,
Aishwarya
Thank you. Yes, that is correct.
Hi @Ashish_Mathur ,
Am back for your expertise, This is regarding the same visualization that you helped me with but this time i am trying to plot a burn down. That is at PI level i need the total planned features & delivered where as when i drill down to sprint i need a burn down of the features based on the sprint dates.
Measures:
Planned feature= distinct count based on due date
Delivered features = distinct count based on Closed date and status = "closed"
I understand that the logic would be TotalForEachPI - PlannedFeaturesForSprint, But I am not sure of the logic for the counts would be with measures
Also if this is not a good solution i dont mind showing only burndown at sprint level with a slicer of PI But the chart would need to start with total like the image below.
Sample Power BI with current measure and updated columns
Thank you.
Hi,
I do not understand your requirement. Please show the result you are expecting in a tabular format with an explanation of how you arrived at those figures. Once the Table is ready, we can simply create a chart from it.
Hi,
Taking PI = uPI_1, Total Planned =19, Total Delivered=14 The following will be the table
Sprint No | PlannedFeatures | PlannedBurndown | DeliveredFeatures | DeliveredBurndown |
1 | 4 | 19-4 = 15 | 3 | 14-3=11 |
2 | 4 | 15-4= 11 | 3 | 11-3=8 |
3 | 3 | 11-3=8 | 2 | 8-2=6 |
4 | 2 | 8-2=6 | 2 | 6-2=4 |
6 | 1 | 6-1=5 | 0 | 4-0=4 |
Chart: xaxis= Sprint No. Two lines - Planned Burndown & Delivered Burndown
Thanks
Hi,
The total of planned is 14 (not 19). Still not clear about your question.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |