Burn chart doesn't work

[Magdelicia]

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 😞

[v-yulgu-msft]

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