add_whatif_parameter
Generate a Power BI what-if parameter with disconnected GENERATESERIES table and SELECTEDVALUE measure for slider-based scenario analysis.
Instructions
Create a WHAT-IF parameter: a disconnected GENERATESERIES calculated table plus a SELECTEDVALUE measure ([ Value]) that picks up the slider selection. Drop the table's column on a slider slicer and reference the value measure in your DAX. The standard Modeling > New parameter pattern.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max | Yes | maximum value | |
| min | Yes | minimum value | |
| name | Yes | ||
| increment | Yes | step / increment between values | |
| sessionId | Yes | ||
| defaultValue | No | default value the measure returns when nothing is selected (optional; defaults to min) |