Forum Discussion
Waterfall report starting value
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...
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!
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 👍
