R T on 21 Jul 2021 12:08:22
Idea
It would be really great if what-if parameters could be linked together so that the total of the what-if slicers were connected using the UI, meaning a change to one parameter would impact the other. This would make what-if parameters far more appealing to use as they would then support multi-factor scenarios where things like percentages in a forecast are impacted by 3 or 4 factors.
Example
As an example, let's say you have 3 what-if parameters showing 3 target percentages, and the total of the percentages needs to equal 100%. If one parameter slicer is set to 50%, the other two should only ever be able to total up to 50% together so all three total 100%.
For more on the example with images, please see my forum post here.