Waterfall creation

[Mokhtar]

Hello Power BI Team,

It's the first time I post on the forum,

Below a quick Idea on what I want to have,

I tried to use Unpivot with an unbreak howerver I always get a total at the end.

Many thanks for your help 🙂 

[v-xuding-msft]

Hi @Mokhtar ,

Well, do you want to remove total bar from WaterFall visual? If you are using a default visual (shown in Visualization pane), I don't think we can implement it. It's a not good workaround to change the total bar color to white. Maybe you could have a try.

If I misunderstand, please share some sample data and your expected results. Then we will understand clearly.

And there are the document and the blog about WaterFall visual. You could take a look at them to learn more.

Waterfall charts in Power BI 

Power BI Waterfall Chart: What’s That All About? 

Best Regards,

Xue Ding

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

[Mokhtar]

Hello @v-xuding-msft ,

thank you for the answer 🙂

please find below the sample data:

Date	Number	Hire	Exit	Transfer IN
31/01/2019	5	6	15	20
31/07/2020	10	9	12	22

I want to display 5 as the first bar on my waterfall then 3 (9-6) the second bar on the waterfall, -3 for the Exit and +2 for the transfer and so on so forth for the other indicators, Until the last bar will be 10 that represent the SUM of the variation.

Below an example of what I expect to have:

Hope I'm cleare 🙂

Many thanks in advance,

Regards,

Mokhtar.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490