Waterfall Chart using different columns

[alfertab]

Hi everyone, I'm having some troubles with Power BI Waterfall Chart and I would like to know if someone could help me.

For the moment I have a table like the following:

Date	Billing before the battery	Solar savings	Battery charge savings	Battery discharge savings	Billing after the battery
October 2023	15,000	-1,500	3,400	-4,760	12,140
November 2023	13,540	-950	2,970	-4,050	11,510
December 2023	14,560	-1,060	3,120	-4,230	12,390

Having the table, I need to have a waterfall chart like the following:

Could someone please help me? 

Thanks 😄

[alfertab]

Yeaaaah, thanks a lot, it was really helpfull

[Anonymous · Accepted solution]

Hi, @alfertab 

Based on your description, adding a Visual Object for Ultimate Waterfall Free and I have created many measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Measure:

new Billing after the battery =

VAR _allBillingafter =

    CALCULATE ( SUM ( 'Table'[Billing after the battery] ) )

VAR _newAllBatterydischarge = - ( _allBillingafter )

RETURN

    _newAllBatterydischarge

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum