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.

Many thanks for your help 🙂 

 

 

Need Help
Show and Tell

3 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity 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.