Power Bi - Edit Parameters

[Johnbl]

Greetings to all,

I am new to Power Bi, and I am sorry if this is reposted but I couldnt find a solution for my problem. 

So I created a report in Power BI and I have a parameter (number list) in Power Query that when it changes value, it also changes the value of a whole column. Now when I edit the parameter value from Power BI interface Home>Transform Data>Edit Parameters it changes the visuals as it should, it works really well.

The problem is that I want to add this action (Edit Parameter) somehow inside my report so the end user can change this value and update the visual, with a slider, dropdown or what ever.

Thank you

[Johnbl]

So to be more spesific, I have a Query[FILL_CUT] with a column named Main Axis Station, which then with the function (Number.RoundUp([Main Axis Station]/Slider_PQ,0)*Slider_PQ) it gives the Station RoundUP Column. The Slider_PQ is a parameter that is a number list (100, 500 ,100), (min,max,increment). Now when I create a new What if Parameter how do I link the value of the new What-if Parameter to Slider_PQ Parameter or directly to the function that calculates the new column.

Thank you in advance

[Johnbl]

Perfect thank you very much for your fast answer I appreciate it.

Could you please guide me throught on how to link the value of new What if parameter I created to the other table?

Thank you very much

[Omid_Motamedise]

You're facing a common limitation in Power BI: parameters in Power Query cannot be changed dynamically within a report by end users. Parameters can only be modified in Power Query (Transform Data) and require a refresh to apply changes. However, you can achieve a similar effect using alternative methods that work within a report:

Instead of a Power Query parameter, you can create a What-If Parameter in Power BI, which allows users to select a value dynamically without requiring a data refresh.

Steps to Create a What-If Parameter:
Go to Modeling > New Parameter > What If Parameter.
Set the Data Type to Whole Number (or Decimal if needed).
Define a minimum and maximum range with step size.
Click OK to generate the parameter table and measure.
Power BI will create:

A new table with values in the specified range.
A slicer to allow users to select values.
Use this parameter in DAX calculations to modify your visual dynamically.