Waterfall chart subtotals.

[Epter]

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. 

[Epter]

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

[v-easonf-msft]

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