Help with burndown charts from Azure DevOps

[arpan_mehetre]

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

[v-angzheng-msft]

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]

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.