Forum Discussion

Pfoerster's avatar
Pfoerster
Icon for Helper III rankHelper III
6 years ago

Overlayed Waterfall Diagramm

Hello again,

currently, I am trying to transform Excel Analysis into Power BI and I am at a point, where I do not have a glue, how to build it up in Power BI.

Goal: The user should have the possibility to compare two planning scenarios (i. e. Budget and Actual) and get as a result a Waterfall Diagramm to see the evolution of Stocks (Starting Stock -> Changes -> Ending stock):

In Excel, it is looking like this:

 

The red columns are the budget, the coloured one are actual developments. Now, the user can see, where differences are coming from. Beside the two Scenarios, the User can also select the period he wants to compare (one specific month, or YTD).

 

Is such a "bridge" possible and if yes, how?

1 Reply