Forum Discussion

xizhouxie's avatar
xizhouxie
Frequent Visitor
8 years ago
Solved

What if parameter help - input changes by itself after hitting enter

I set the what if parameter to range from 1000 to 5500, with increment of 1.  Because of the way that I am using the what if parameter, I need the user to input a specific number, and not just use th...
Need Help
  • xizhouxie's avatar
    xizhouxie
    8 years ago

    v-huizhn-msft Did you set the range as the same as mine? I think it's because of the range being too big and the numbers are being sampled.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi xizhouxie,

If you want to decrease 1 from the selected value in parameter. When you create a what-if parameter, which generates a table named "Parameter", and a measure [Parameter Value]. You can create another measure using the formula using the formula below.

decrease1 = Parameter[Parameter Value]-1


Please see the screenshot, when I select 3 in parameter, the measure returns 3.



If you want to sepefic list in the parameter, Power BI can't support the feature until now. You can create a idea here.

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This parameter problem is still an issue in 2021.   Impossible to use the parameter slider to go by $1.00 increments when dealing with large number ranges.   This really needs to be fixed.