Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Burndown Graph with deadlines

Hi all,   I'm trying to create a graph that shows the expected burndown of milestones of a program. I would like to compare the planned dates with the actual dates. My goal would be two lines that ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    Try below measures.

    Planned to do = 
VAR _count =
    CALCULATE (
        COUNT ( 'Table'[Milestone Name] ),
        FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] > MAX ( 'Date'[Date] ) )
    ) + 0
RETURN
    IF ( ISBLANK ( SELECTEDVALUE ( 'Table'[Planned date] ) ), BLANK (), _count )

    Actual to do = 
VAR _count =
    CALCULATE (
        COUNT ( 'Table'[Milestone Name] ),
        FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] > MAX ( 'Date'[Date] ) ),
        USERELATIONSHIP ( 'Date'[Date], 'Table'[Actual Date] )
    ) + 0
VAR _date =
    CALCULATE (
        SELECTEDVALUE ( 'Table'[Actual date] ),
        USERELATIONSHIP ( 'Date'[Date], 'Table'[Actual Date] )
    )
RETURN
    IF ( ISBLANK ( _date ), BLANK (), _count )

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-jingzhang ,

Thank you for your answer! 
I understand that the measure ends at 1, since the last date has one value. I think the measure works the way it should, unforunately though, it doesn't achieve what i'm trying to achieve. I tried changing >= to >, but it doesn't reach my goal.
I would like to get a graph that ends at 0, based on the idea that if all milestones have indeed been finished by the last date the "to do" value should be 0 and not 1. 
This might not be something that is possible to achieve with a measure, I wouldn't know. 
The reason I would like to get to 0 is that in my real data I have 150+ milestones at the last date, which results in a burndown graph that ends at 150+ somewhere in the middle of the graph, which is not the expected end, because you expect to end at 0. Hence the business is not happy with my graph 😉

I hope this is a clear explanation and I'm curious to know if there is a solution for it. A measure would be really nice, but if there is another way that would also be good.

Kind regards, 
Odi

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

It is because blank values don't show in the chart. You could add +0 at the end of the measure.

Planned to do = 
CALCULATE (
    COUNT ( 'Table'[Milestone Name] ),
    FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] > MAX ( 'Date'[Date] ) )
) + 0

 

Regards,
Jing