Target adjustment in Power BI Waterfall

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at Shape and combine multiple data sources and use SWITCH to add a measure.

Measure =
SWITCH (
    SELECTEDVALUE ( 'Table'[category] ),
    "rain", [Measure 1],
    "maintenance", [Measure 2],
    [Measure 3]
)

[Anonymous]

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!