Forum Discussion

mofu1401's avatar
mofu1401
Helper I
1 year ago
Solved

Parameters

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, i...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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.