Forum Discussion

Epter's avatar
Epter
Frequent Visitor
4 years ago

Waterfall chart subtotals.

Hi 

I'm trying to build a waterfall chart but i keep hitting the limits of my knowlege 🙂

 

I have a quite bacis dataset that looks like this 

and i want to make a waterfall diagram that are grouped into a couple of sections. 

I want to start with the opening balance then add addition, service and revenue. I then need a total for the month before the graph continues with the budget for next month with Won 1 and Won 2 and spend are shown and finally it should ned in a grand total. it should look a bit like this

I Therefore i have made a sort table so i can ger everything into PowerBI

 

So far so good, but when i try to combine everything it dont really work. I can get part of the solution when i enter Category and Category 2 into the Category field. but when i try to add one of them to the breakdown everything goes wrong as you can see below. 

 

 

 I hope that some of you have some idears for me. 

2 Replies

  • Epter's avatar
    Epter
    Frequent Visitor

    I still have this problem, so any help would be apreciated. 

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support

      Hi,  Epter 

      It seems that sort columns does not work here.

      If you have no idea about your problem, you can open a support ticket with MSFT to seek technical support ,  they will have better suggestions.

       

      Best Regards,
      Community Support Team _ Eason