cancel
Showing results for
Did you mean:
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 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).

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

5 REPLIES 5
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 !!
Helper I

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!

Super User

@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 !!
Helper I

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

Helper I

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

Announcements