Forum Discussion

Johnbl's avatar
Johnbl
Frequent Visitor
1 year ago
Solved

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...
  • v-hashadapu's avatar
    1 year ago

    Hi Johnbl , Thank you for reaching out to the Microsoft Community Forum.

     

    Please try this:

    1. 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
    2. 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.
    3. 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.
    4. 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.
    5. 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.