Parameters

[mofu1401]

hi all,

i am trying to use Parameters for users to key in the price and use it for some calculation.

However, it does not seem to be able to key in the exact value.

For example if i key in 1800, it will adjust to 1797, each increment is 89 instead.

Is this the normal behaviour of Parameters?

Would there be alternatives methods for user to key in a value and use it for calculation?

Thank all .

[rajendraongole1 · Accepted solution]

Hi @mofu1401  - Yes, this behavior is due to the way numeric range parameters work in Power BI. When you set an increment value, Power BI distributes the range evenly based on that increment. However, the issue arises when Power BI internally determines an increment that doesn’t align exactly with your expected values. That’s why you're seeing adjustments like 1797 instead of 1800.

alternatively you can create a input method, by creating a Disconnected Table that contains a list of values users can select from.This works well if the number of choices is reasonable.

HOpe this helps.