Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I want to store the values in a table and display them, which the user enters using the what-if parameter.
For example,
I have entered 230, 330 ,430 one by one , in a single what-if parameter ,
I want to display in a table 230,330 & 430.
I am unable to do so,
Please help
Solved! Go to Solution.
Hi @Anonymous ,
Are you referring to the information of the following pictures:
After creating the parameter information here, a calculation table with a minimum value of 230, a maximum value of 430, and an increase in the number of rows in increments of 100 is automatically generated. This table is used to store data and will automatically generate a slicer for us to use.
You can also use slicers and functions to apply them to other tables:
Measure =
MAX('Table'[Value]) * 'Parameter'[Parameter Value]
Refer to:
Use parameters to visualize variables - Power BI | Microsoft Learn
If I have misunderstood your meaning, please provide your pbix without privacy and desired output.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Are you referring to the information of the following pictures:
After creating the parameter information here, a calculation table with a minimum value of 230, a maximum value of 430, and an increase in the number of rows in increments of 100 is automatically generated. This table is used to store data and will automatically generate a slicer for us to use.
You can also use slicers and functions to apply them to other tables:
Measure =
MAX('Table'[Value]) * 'Parameter'[Parameter Value]
Refer to:
Use parameters to visualize variables - Power BI | Microsoft Learn
If I have misunderstood your meaning, please provide your pbix without privacy and desired output.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
a calculation table with a minimum value of 230, a maximum value of 430, and an increase in the number of rows in increments of 100 is automatically generated is not what I am looking for.
for example , if i enter 230 , 238 & 433 using what if parameter.
the table will show all the entered number by the user
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 69 | |
| 46 | |
| 44 | |
| 28 | |
| 19 |
| User | Count |
|---|---|
| 199 | |
| 129 | |
| 102 | |
| 69 | |
| 55 |