What-if parameters only applying to specific years depending on region selected

[dansimmons]

Hi,

I'm trying to create a set of what-if parameters (sliders) that work in a specific way.

As default, I am displaying volumes by year (2022-2029) for three regions ('A', 'B' and 'C') on a simple line chart. I have a slider that interacts with the single 'Volume' line to introduce a second (dashed) 'Volume forecast test' line to illustrate what-if scenarios.

I now want to introduce 3 x new sliders at the top of the file - one for region A, one for region B, and one for region C. There are three very important requirements:

• The 3 new sliders should only affect data between 2022 and 2023 (i.e. 2024-2029 values should remain the same when the sliders are changed).
• The existing slider should only interact with 2024-2029 data.
• The 3 new sliders should only interact with one region each (one for region A, one for region B and one for region C), and show the impact on the existing overall chart. For example, when I move my current slider to '2', the 2023 value increases from '38700' to '77400'. I want it to work so that when the new 'Region A' slider is moved, it only updates the values for region A (B and C should stay the same). In this example, I'd expect the 2023 value to increase from '38700' to '50400' when changing the new 'Region A' slider to '2'.

Please see .pbix file here.

Any help would be hugely appreciated.

Thanks very much 🙂

[lbendlin]

The existing slider should only interact with 2024-2029 data

What do you expect to happen to the 2022/2023 data? set the parameter to 1 ?

[dansimmons]

@lbendlin thanks for your reply 🙂

Correct - when using the existing slider, the 2022-2023 data should remain at default values.

Your screenshot looks promising.. I suppose the next stage is introducing the 3 x new sliders?

[dansimmons]

Hi @lbendlin - is there any further detail I can provide you with to work out how to incorporate the 3 x new sliders? Really appreciate you looking into this 👍

[lbendlin · Accepted solution]

see attached.