Forum Discussion

Mokhtar's avatar
Mokhtar
Frequent Visitor
6 years ago

Waterfall creation

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. ...
Need Help
Show and Tell
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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's avatar
    Mokhtar
    Frequent Visitor
    6 years ago

    Hello v-xuding-msft ,

     

    thank you for the answer 🙂

     

    please find below the sample data:

     

    DateNumber HireExitTransfer IN
    31/01/2019561520
    31/07/20201091222

     

    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.