Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Waterfall Chart

 

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]










 

 

Waterfall Chart

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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