Waterfall chart based on two columns

[Hamdan1234]

Hello,

I want to have waterfall chart it should represent three columns value one with total activities and two other columns should be showing increase and decrease column data all these will be based on date as axis. I am attaching my table below as well. 

Month	Total Active	Opened accounts (**bleep**)	Closed accounts (**bleep**)	Increase	Decrease	Difference
Sep-19	9665
Apr-21	8299	1852	3218	1852	3218	-1366
Jun-21	8255	1896	3306	44	-88	-44
Sep-21	7993	1938	3609	42	-303	-262

[v-henryk-mstf · Accepted solution]

Hi @Hamdan1234 ,

Based on the test data you provided, I don't think it's possible to create the corresponding waterfall chart. I think the choice of clustered column chart can show the change of increase or decrease more visually.

For waterfall visual details, you can read related document link.

Waterfall charts in Power BI - Power BI | Microsoft Docs

If the problem is still not resolved, please provide effective data models and desired results. Looking forward to your feedback.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hamdan1234]

Hello @lbendlin ,

Actually I have the column for Total acive so I want Total active as big bar then increase and decrease values as per column. So as you can see for total active firt value it would be 9665 but it does not have increase and decrease so it would be zero increase and decrease, then when total active in second row woulde 8299 then increase and decrease value would be 1852 and 3218 as column increase and decrease 

[lbendlin]

How do you get from 9665 to 8299 without a decrease? Can you show a sample chart?

[Hamdan1234]

We don't have data for September before 2019 so we don't know how much cases were closed or opened.

[lbendlin]

A waterfall chart needs to have a baseline (starting) value.  Maybe use a different visual.

[lbendlin]

Like this?