Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Anonymous
Not applicable

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:

rb161604888_0-1631056040033.png

 

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:

rb161604888_1-1631056040037.png

 

Below is the sample data for week 2. After week 2 there are 26 incomplete items.

rb161604888_2-1631056040039.png

 

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:

rb161604888_3-1631056040041.png

 

To summarize:

  1. All processed data resides in the table
  2. Add this data automatically to the table to build burndown chart
  3. Build the burndown chart and update every week

Thanks in advance!

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@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.

V-pazhen-msft
Community Support
Community Support

@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

Anonymous
Not applicable

@V-pazhen-msft thanks for your response. Below is the sample data:

 

Table 1:

image001.png

Table 2:

image002.png

Relationship:

image003.png

 

 

Anonymous
Not applicable

@V-pazhen-msft did you get a chance to look at this?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.