Forum Discussion
Power Bi - Edit Parameters
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
Hi Johnbl , Thank you for reaching out to the Microsoft Community Forum.
Please try this:
- Go to Modeling -> New Parameter -> What If Parameter. Set the Data Type to Whole Number (or Decimal if needed). Define the minimum and maximum range with the step size. Click OK
- Power BI will create a new table with values in the specified range and a slicer to allow users to select values. You will also get a measure like Parameter Value which holds the selected value from the slicer.
- Instead of using Slider_PQ directly in your Power Query, you can use the What-If Parameter measure in your DAX calculations. Create a new calculated column in your table using DAX.
- Add the slicer created by the What-If Parameter to your report. This slicer will allow end users to dynamically change the parameter value, and your visuals will update accordingly.
- Also please refer this document:
Use parameters to visualize variables - Power BI | Microsoft Learn
Thank you Omid_Motamedise for your prompt and appropriate response.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
8 Replies
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.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
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
Hi Johnbl , Thank you for reaching out to the Microsoft Community Forum.
Please try this:
- Go to Modeling -> New Parameter -> What If Parameter. Set the Data Type to Whole Number (or Decimal if needed). Define the minimum and maximum range with the step size. Click OK
- Power BI will create a new table with values in the specified range and a slicer to allow users to select values. You will also get a measure like Parameter Value which holds the selected value from the slicer.
- Instead of using Slider_PQ directly in your Power Query, you can use the What-If Parameter measure in your DAX calculations. Create a new calculated column in your table using DAX.
- Add the slicer created by the What-If Parameter to your report. This slicer will allow end users to dynamically change the parameter value, and your visuals will update accordingly.
- Also please refer this document:
Use parameters to visualize variables - Power BI | Microsoft Learn
Thank you Omid_Motamedise for your prompt and appropriate response.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.Hi Johnbl , Thank you for reaching out to the Microsoft Community Forum.
Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.Hi @Johnbl , Thank you for reaching out to the Microsoft Community Forum.
Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.Step by step guide:
You can find how to create and manage parameter here:
https://ashishcoder.com/courses/power-bi/power-query-editor/parameters-in-powerbi.htmlHi @Johnbl , Thank you for reaching out to the Microsoft Community Forum.
Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.
