cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Odi
Helper I
Helper I

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
 
5 REPLIES 5
amitchandak
Super User
Super User

@Odi , Try a measure like

 

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

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:

Odi_1-1613055225589.png

It doesn't appear to work for some reason when i use the "Select all" option in the filter pane:

Odi_2-1613055498451.png

 

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!

 

@Odi , refer to the file attached after signature

 



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors