Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create declining graph based on date and a count

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 approvedCount of Milestone Name
31-12-20202
30-4-20211
30-6-20211
30-6-20221
30-10-202117
31-12-20213

 

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). 

 
I have read numerous posts on burndown charts in the community but i still can't seem to get this working. I'm fairly new to powerbi and any help is much appreciated 🙂
 
Thank you!
 
P.S. The complete table looks like this:
End date approvedMilestone Name
31/12/2020 00:00Example 1
31/12/2020 00:00Example 2
30/04/2021 00:00Example 3
30/06/2021 00:00Example 4
30/09/2021 00:00Example 5
30/10/2021 00:00Example 6
30/10/2021 00:00Example 7
30/10/2021 00:00Example 8
30/10/2021 00:00Example 9
30/10/2021 00:00Example 10
30/10/2021 00:00Example 11
30/10/2021 00:00Example 12
30/10/2021 00:00Example 13
30/10/2021 00:00Example 14
30/10/2021 00:00Example 15
30/10/2021 00:00Example 16
30/10/2021 00:00Example 17
30/10/2021 00:00Example 18
30/10/2021 00:00Example 19
30/10/2021 00:00Example 20
30/10/2021 00:00Example 21
30/10/2021 00:00Example 22
31/12/2021 00:00Example 23
31/12/2021 00:00Example 24
31/12/2021 00:00Example 25
 
Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try a measure like

     

    Count Milestones = calculate(DISTINCTCOUNT(MilestonesAndDependencies[Milestone Name]), filter(allselected(MilestonesAndDependencies), MilestonesAndDependencies[End date] > min(MilestonesAndDependencies[End date])))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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!