Forum Discussion

Magdelicia's avatar
Magdelicia
Frequent Visitor
9 years ago

Burn chart doesn't work

Hi i want to make a burn chart with the planified budget and the actual budget burned. Here are my formulas   Burn actual budget = CALCULATE((sumx(project_budget,project_budget[$_budget])) - sum(TA...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Magdelicia,

 

Please first refer to below links which show how to create Burndown chart:

Creating burndown charts for Project using Power Pivot and Power Query

Burndown chart for data progress

 

For further analysis, please share sample data so that I can test for you. I noticed that in your formulas, you used several columns from four different tables, you'd better also tell us the relationship between these tables. Besides, if possible, show us your expected output.

 

Regards,
Yuliana Gu