Forum Discussion
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
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] )
2 Replies
- v-chuncz-msft
Community Support
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] )- AnonymousNot 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!