cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
desertislesql Helper III
Helper III

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 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

 

6 REPLIES 6
Super User IV
Super User IV

Re: Waterfall report starting value

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

desertislesql Helper III
Helper III

Re: Waterfall report starting value

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.

Super User III
Super User III

Re: Waterfall report starting value

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

klabir Helper V
Helper V

Re: Waterfall report starting value

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

 

M8.PNG

denpries Helper III
Helper III

Re: Waterfall report starting value

Yeah @klabir, thats great and all, but with 500+ users i end up paying tweny kazillion euros.

Not an option.

klabir Helper V
Helper V

Re: Waterfall report starting value

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

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors