Forum Discussion
Burndown chart using table data
Hello All,
I want to build a burndown chart (separate chart for each item) for each of the 3 items in the slicer, i.e., Tree1, Tree2 and Tree3 for Unit 1 as shown below.
Sample data:
Filtered data for Tree1 for week 1 shows that a total of 44 items have been completed out of 90 leaving 46 incomplete items. This data gets refreshed every week.
Filtered Data (Example) – Week 1:
Below is the sample data for week 2. After week 2 there are 26 incomplete items.
As this data gets refreshed everyweek, I would like to add this data to the data used for building the burndown chart.
Data buildup for the burndown every week:
Date | Incomplete Items |
8/30/2021 | 46 |
9/6/2021 | 26 |
9/13/2021 | |
9/20/2021 | |
9/27/2021 | |
10/4/2021 | |
10/11/2021 | |
10/18/2021 | |
10/25/2021 | |
11/1/2021 | |
11/8/2021 | |
11/15/2021 | |
11/22/2021 | |
11/29/2021 | |
12/6/2021 |
How can I build a burn down chart using the examples above?
Example burndown chart for Tree 1:
To summarize:
- All processed data resides in the table
- Add this data automatically to the table to build burndown chart
- Build the burndown chart and update every week
Thanks in advance!
4 Replies
- AnonymousNot applicable
Anonymous
All visuals including charts are based on data table not on others visuals. Can you share the sample data table not a visual table, A sample pbix would be best. Also include the relationships, because it seems the date and incomplete item column are not in the same table with your fact table.Paul Zheng _ Community Support Team
- AnonymousNot applicable
Anonymous thanks for your response. Below is the sample data:
Table 1:
Table 2:
Relationship:
- AnonymousNot applicable
Anonymous did you get a chance to look at this?
- AnonymousNot applicable
Anonymous
You should have a date column linked with the calendar table in order to create a burn down chart. The above information is not enough. Please refer to the video and post below. You can add the tree type in the legend in your case.Power BI - Burndown Chart (Fixed X-Axis) - YouTube
Solved: Burndown chart for data progress - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.