Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

@Anonymous , Try a measure like

 

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

Anonymous
Not applicable

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!

 

@Anonymous , refer to the file attached after signature

 

Anonymous
Not applicable

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 

Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.