Forum Discussion

arpan_mehetre's avatar
arpan_mehetre
Regular Visitor
4 years ago

Help with burndown charts from Azure DevOps

I was able to follow below this article and created a burndown chart in PowerBI. The article shows how to create the sprint burndown for User Stories, Bugs. The data is being pulled using OData queries and the server side grouping is performed to dind the values for each day between Iteration start and end dates. DateValue is added to the axis to show the sum of efforts for each date. 

The DateValue field have values for 12AM on each date and so I get to track the correct burndown status one day after the current sprint closure. 

I need help with pulling the values in DateValue field for 9pm for each day.

 

sample

Need Help

2 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, arpan_mehetre 

     

    If you mean changing the 12AM to 9 PM in the column, maybe you can use the column plus the duration(#duration(0,21,0,0)) in power query.

    If not, this may not help. Since I have no experience with OData, I hope someone can help you solve it.

     

     

    Best Regards,
    Zeon Zheng

    • arpan_mehetre's avatar
      arpan_mehetre
      Regular Visitor
      4 years ago

      Hi v-angzheng-msft ,

       

      Thanks for responding.


      I guess I would need to pull the data for 9pm and hence I will need to modify the odata query to pull the data at 9pm time.