Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Burndown Chart

Hi,   I am trying to create a burndown graph for a list of software activities (user stories), which have 3 date fields: Baseline Completion Date - Assigned to all activities when they are create...
Burndown
running count
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, Anonymous 

    If you do not want to show a spike , in my thought , we can compre this value before it  and then we can create a measure based on the [Actual Value] measure:

    Measure = var _cur_date = MAX('Calendar'[Date])
var _preDate = MAXX(FILTER( ALLSELECTED('Table')  , 'Table'[Date]< _cur_date && 'Table'[Attribute] = "Actual Completion Date") ,[Date])
var _prevalue = CALCULATE( SUM('Table'[Baseline Burndown]) , 'Table'[Attribute]="Actual Completion Date" , 'Calendar'[Date] = _preDate)
return
IF([Actual Value]=BLANK(), BLANK() ,IF(ABS( [Actual Value]-_prevalue)>2 ,BLANK() , [Actual Value]))

     

    Then we can put this measure on the viusal and we can hide this spike in it :

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-yueyunzh-msft ,

 

Thank you, this is very close to what i require and inspiring me to look at different ways but there is an issue that I wish to overcome which is well illustrated in your example where there is a spike caused by early closure of a record (1st June). I would like the chart to burn down incrementally such that on this date only a burndown of -1 is achived. This drove me (unsuccessfully) to using COUNT and disregarding the 'Baseline Burndown' field. How can I achieve this?

 

Thanks

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, Anonymous 

If you do not want to show a spike , in my thought , we can compre this value before it  and then we can create a measure based on the [Actual Value] measure:

Measure = var _cur_date = MAX('Calendar'[Date])
var _preDate = MAXX(FILTER( ALLSELECTED('Table')  , 'Table'[Date]< _cur_date && 'Table'[Attribute] = "Actual Completion Date") ,[Date])
var _prevalue = CALCULATE( SUM('Table'[Baseline Burndown]) , 'Table'[Attribute]="Actual Completion Date" , 'Calendar'[Date] = _preDate)
return
IF([Actual Value]=BLANK(), BLANK() ,IF(ABS( [Actual Value]-_prevalue)>2 ,BLANK() , [Actual Value]))

 

Then we can put this measure on the viusal and we can hide this spike in it :

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly