Waterfall Chart

[Anonymous]

Hello guys,
I need your help to build a Waterfall chart.
It's a difficult challenge to get what I want.

1º I can't put the total value of the origin and destination kilos, that is, the origin value would be total value in 2021 and destination total value in 2022. And then also compare with the month of the respective years.
2º In the middle I want to see the variation of kgs by country in the period in question. Thanks for help and attention.
The most I could do was this:
One measure only: Variation 2022 vs YAG = [Kilos produced today 2022]-[Kilos produced YAG 2021]

[Anonymous]

Hello @v-henryk-mstf 

What I pretend to do is this in excel (Graph on the right) and I can't do it in Power BI.
I have in Power Bi the data 2021 and 2022, as well as the variation (Delta Column).

We have to work with the variation data (Column Delta) and the difficulty is to put the totals for the year 2021 and 2022 (as shown in the graph with Blue color).

I hope I made it clear.
Thanks,
João Rodrigues

[v-henryk-mstf]

Hi @Anonymous ,

Can you provide a screenshot of the desired results and describe them, as well as the test data, so that I can answer them for you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry