Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am looking for a waterfall report to look exactly like this Office 365 page. http://bit.ly/1MQVmJb I want to have a starting value of budgeted value, chart the variances and end up with the actual value. I don't see how to do the same thing in Power BI as I can't figure out how to start say with Budget and get the variances displayed to end with Actuals. Any assistance would be most appreciated.
Regards,
Ginger
Hello @desertislesql
have a look and download our PowerBI Ultimate Waterfall Chart which follows somehow IBCS
http://dataviz.boutique/2017/03/22/powerbi-ultimate-waterfall-custom-visual/
BR
Klaus
Yeah @klabir, thats great and all, but with 500+ users i end up paying tweny kazillion euros.
Not an option.
no, contact me for unlimted use in your enterprise, its cheap, i promise. leave your email in one of our contact form on our website to getin touch.
THX
Klaus
Yeah, the issue that I see is that there is no way to set individual data values as "totals", which baseline to 0 instead of "floating". I can't see a way around that at present.
That's bad news. I was hoping that I was just missing something. It strikes me as odd that I could do what I want in Excel 2016 and not Power BI.
You can achieve it by data modelling (see this file).
Only thing I couldn't figure out is how to give the first column a different colour. Watch out for the sort-by-index column!
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
I like it in that you have created a work around. I don't like that MS still haven't made it easier all these years later, even though it's easy in Excel. Good work by you though 👍
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
81 | |
64 | |
49 |
User | Count |
---|---|
121 | |
109 | |
81 | |
67 | |
67 |