Forum Discussion
dswallow
Helper I
Helper IBurndown Chart using Start and End date fields on x axis
- 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 |
1 Reply
- amitchandak
Super User
dswallow , Based on what I got you can generate all the dates using one these two method and use that column
DAX
Power query
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
