Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Target adjustment in Power BI Waterfall

Hi Everyone,

We have a requirement to create waterfall with dynamic adjustments of "Target" based on "Actual" values.
Our waterfall works well, without following extreme conditions and adjustments.

Description:
In normal scenario, we have 12 working hours in a day divided into two categories i.e. 6 productive hours and 6 non-productive hours (rain - 2 hours, maintenance - 2 hours, break - 1 hours and pray - 1 hours).
Let's say, we have productivity of 100 per hour then total production (Budget) becomes 6 * 100 = 600 for that day.
Let's assume, it's raining for 8 hours then in waterfall it is showing loss of production for 8 * 100 = 800 (in negative) for that day due to Rain.
Now, since this 8 hours can be used for other non-productive things (maintenance, break and pray). We need to adjust these other loss and want to utilize the rain loss in other non-productive hours. This will decrease rain loss from 800 to somewhat 500.


Now let's follow the shared screenshot - 1:

Budget = 285.25K
Rain = -312.5K

Requirement is to set Rain = -194K (screenshot - 2)
Adjustment of difference = 312 - 194 = 117.5K into other categories (screenshot - 2)

Any ideas or suggestions will be appreciated.

 

Link to screenshots : Screenshots 

 

Thanks,
Ankesh

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for your response.

      But, in this case we can't make the calculated columns before adjustments. What we need is, runtime adjustment and creation of waterfall.

       

      Thanks!