March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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:
Thanks in advance!
@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.
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
86 | |
76 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |