Forum Discussion
Johnbl
1 year agoFrequent Visitor
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) i...
- 1 year ago
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.
Ashish_Goel_
1 year agoFrequent Visitor
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.html