Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 months ago
Solved

Waterfall Chart

I want to show a Book Value roll-forward using a waterfall chart in Power BI but I need to be able to determine the start and end points (BOP and EOP) but also need to determine the steps in between ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    7 months ago

    Hi Anonymous, 

    Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to Ashish_Mathur, for his inputs on this thread. I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

     

    outcome:

    I am also including .pbix file for your better understanding, please have a look into it.

     

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum

Anonymous's avatar
Anonymous
Not applicable
7 months ago

Hi, the data is in the snap shot of the chart. I'm expecting to have BOP (2Q) Balance as the starting point, then drivers in between (acq, sales, FX, etc.) and end with EOP (3Q) Balance. For example:

BOP (start) = 100

acquisitons = 300

sales = -50

maturities = -100

FX = 120

Impairments = 200

EOP (ending balance) = 570

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 months ago

There is really nothing i can do with a snapshot.