Forum Discussion
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
- EpterFrequent Visitor
I still have this problem, so any help would be apreciated.
- v-easonf-msft
Community 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