Forum Discussion

JJ2022PBI's avatar
JJ2022PBI
Helper I
1 year ago

Waterfall Charts - help needed please!

Hello,   I would like to create a waterfall chart showing the movement in a bank account between two user defined dates. The categories used in the waterfall would be;   1) Opening Balance [the u...
Need Help
JJ2022PBI's avatar
JJ2022PBI
Helper I
1 year ago

Thank you Dino Tao.

 

You data tables are similar to mine. I was hoping to do something slightly different. The end result would be something like this and instead of having 'Total' at the end it has the month which the suer has selected. Example in Excel below:

 

 

So the money in is the total money in between Oct-23 and Jul-24, same for money out and growth.

 

Thank you very much for your help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi JJ2022PBI ,

    Sorry, the total in the default waterfall chart of Power BI cannot be modified. This is by design. However, the total itself shows the final result calculated based on the increase or decrease of the value and the initial calculated value (as long as your DAX is written correctly), which is the Closing Balance of the last day of the date selected by your slicer.


    Best Regards,
    Dino Tao