Forum Discussion
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(TABLE(invoice amount),
FILTER(ALL(Time[date]),
Time[date] <= MAX(Time[date])))
Burn futur budget == CALCULATE([Burn actual budget]- SUM(projet_assignment[$_assignment]),
FILTER(ALL(Time[date_dt]),
Time[date] <= MAX(Time[date])))
What bothers me is when i want to see the trend per year the line chart doesn't look like a burn chart at all... I need helpthe result :(
1 Reply
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
