Burndown Chart using Start and End date fields on x axis

[dswallow]

• I am trying to create a burndown chart but am having issues with how to use my data fields available. 
• I would like to view the whole sprint duration on the x-axis based on my sprint start and end date fields. 
• At the moment I am placing the date field (adding the row of data for each day extracted) on my x-axis but this is only showing until the current date (latest day of extract) whereas I would like it to show up until the end date. 

My Dataset 

ID	Date (Of Extract)	Iteration Start Date	Iteration End Date	Remaining Hours
1	15/08/22	15/08/22	25/08/22	10
1	16/08/22	15/08/22	25/08/22	9
2	15/08/22	15/08/22	25/08/22	12
2	16/08/22	15/08/22	25/08/22	6

[amitchandak]

@dswallow , Based on what I got you can generate all the dates using one these two method and use that column

DAX

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Power query
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2