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 🙂
