Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I still have this problem, so any help would be apreciated.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |