Create parameters with the what-if analysis

  • 1 minute

What-if analysis allows you to create a numeric adjustable parameter value, interact with the value as a slicer, and visualize different values in your report. You can choose the data type that you want to use, along with increments and default values. This feature allows you to manipulate the data to test different scenarios.

The What-if parameter allows you to dynamically perform what-if analysis by using a slider bar to visualize changes to a calculation.

In the preceding image, you can analyze what might happen to your sales by category if you were to discount at a different percentage. With the same changes to the discount percentage, you can analyze how they would affect your historical value. Furthermore, you could also make assumptions about the relationship between your what-if discount amount and the corresponding increase in sales quantity.