Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

How to add data from what if parameter to a table in dashboard

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi  @Anonymous ,

Are you referring to the information of the following pictures:

vyangliumsft_0-1692928448479.png

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.

vyangliumsft_1-1692928448480.png

You can also use slicers and functions to apply them to other tables:

Measure =
MAX('Table'[Value]) * 'Parameter'[Parameter Value]

vyangliumsft_2-1692928460317.png

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi  @Anonymous ,

Are you referring to the information of the following pictures:

vyangliumsft_0-1692928448479.png

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.

vyangliumsft_1-1692928448480.png

You can also use slicers and functions to apply them to other tables:

Measure =
MAX('Table'[Value]) * 'Parameter'[Parameter Value]

vyangliumsft_2-1692928460317.png

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.

Anonymous
Not applicable

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.