What-if scenarios are very important as they allow users to project what future values will look like depending on one or more variables.
In our recipe, we will reuse the simple what-if scenario from a previous recipe, Inputting data values. The only difference here is that we will use a horizontal slider instead of inputting the values with text.
Set up the sales data as shown circled in red in the following screenshot, and have a column chart ready on the canvas. You can also reuse the column chart from the previous recipe.
Insert a Horizontal Slider component from the Single Value | Horizontal Slider section of the Components window into the canvas.
Set the Title text to
Forecasted Change
. Bind the Data to cell D3 highlighted in yellow. Set the Minimum Limit to-20
and Maximum Limit to20
in the Scale section.Go to the Appearance section of the slider properties and make sure that the Limits checkbox is checked.
Now, in...