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.
Forecasted Change
. Bind the Data to cell D3 highlighted in yellow. Set the Minimum Limit to -20
and Maximum Limit to 20
in the Scale section.In this example, the slider controls the what-if value in cell D3. The chart data cells take the user's what-if rate and add it to the current sales values.
For a more complex what-if example, read the What-if scenario – Mortgage Calculator recipe in Appendix A, Real-world Dashboard Case Studies.