Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'm trying to create a graph that shows the expected burndown of milestones of a program. I have a table with numerous names for milestones, where a milestone name can appear multiple times for different projects [Milestone Name] , and a date on which the milestons will be completed [End date approved]. A sample of the data that i would like to use looks like this:
End date approved | Count of Milestone Name |
31-12-2020 | 2 |
30-4-2021 | 1 |
30-6-2021 | 1 |
30-6-2022 | 1 |
30-10-2021 | 17 |
31-12-2021 | 3 |
Please note that the second column is a count of the Milestones that will be finished on that day in this example.
What i would like to create is a graph with the date on the x- and the amount of milestones to go on the y-. Thus it starts at the first date, with the total amount of milestones to go, and should and at 0 on the last date (31-03-2022).
End date approved | Milestone Name |
31/12/2020 00:00 | Example 1 |
31/12/2020 00:00 | Example 2 |
30/04/2021 00:00 | Example 3 |
30/06/2021 00:00 | Example 4 |
30/09/2021 00:00 | Example 5 |
30/10/2021 00:00 | Example 6 |
30/10/2021 00:00 | Example 7 |
30/10/2021 00:00 | Example 8 |
30/10/2021 00:00 | Example 9 |
30/10/2021 00:00 | Example 10 |
30/10/2021 00:00 | Example 11 |
30/10/2021 00:00 | Example 12 |
30/10/2021 00:00 | Example 13 |
30/10/2021 00:00 | Example 14 |
30/10/2021 00:00 | Example 15 |
30/10/2021 00:00 | Example 16 |
30/10/2021 00:00 | Example 17 |
30/10/2021 00:00 | Example 18 |
30/10/2021 00:00 | Example 19 |
30/10/2021 00:00 | Example 20 |
30/10/2021 00:00 | Example 21 |
30/10/2021 00:00 | Example 22 |
31/12/2021 00:00 | Example 23 |
31/12/2021 00:00 | Example 24 |
31/12/2021 00:00 | Example 25 |
@Anonymous , Try a measure like
Count Milestones = calculate(DISTINCTCOUNT(MilestonesAndDependencies[Milestone Name]), filter(allselected(MilestonesAndDependencies), MilestonesAndDependencies[End date] > min(MilestonesAndDependencies[End date])))
Hi Amitchandak,
Thank you so much for the quick reply! It appears to work well, but only if if select each date seperately in the filter pane:
It doesn't appear to work for some reason when i use the "Select all" option in the filter pane:
Any idea as to why this is? If it's possible to use the "Select All" option i can use this measure and graph for all the projects and simply filter on a project to show the graph. If i have to select the specific dates for each program i'll have to make specific graphs for each project.
Thank you!
@Anonymous , refer to the file attached after signature
Hi Amitchandak,
I've used the measure you provided in second report and I only now noticed that the graph doesn't end at 0. In your example it ends at 3 and since this was so close to 0 I didn't notice but when I used this measure on a different dataset it ended at 223, because the deadline for 223 items is on the last day. It would be really nice if the graph actually ended at 0. Do you have any idea how to get do that?
Kind regards,
Odi
Hi Amitchandak,
I did some extra investigating and apparently there is something wrong with my relations, cause the filter i'd like to use doesn't filter out all the rows that it should. So your suggested measure is the perfect solution, i just need to fix something in the many relations my file has 🙂
Thank you so much!
Odi
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |