Forum Discussion

Pra2010Gha's avatar
Pra2010Gha
Helper I
9 months ago
Solved

Decimal level parameter not working

Hello I am trying to pass value to a decimal parameter say 45.67 but it is rounding up to some wierd number.I want it to show the entered value as it is like if i enter 45.67 it will show 45.94 for...
  • v-achippa's avatar
    v-achippa
    9 months ago

    Hi Pra2010Gha,

     

    The numeric range parameter or slicer in power bi does not support a search box, it only allows selecting or typing a range of numeric values.

    If you need a search option, then create a text version of your numeric values and use that in a dropdown slicer instead, for example like below:

    ValueText = FORMAT(YourTableName[ParameterValue], "0.00")

    Then add a slicer using ValueText and it will automatically show a search box where you can type numbers like 45.67.

     

    Thanks and regards,

    Anjan Kumar Chippa

ANVS's avatar
ANVS
Advocate II
9 months ago

Hello Pra2010Gha

I suggest these 2 options for the workaround:


Option 1: Increase Increment Precision

Try setting the Increment value to 0.001 or even smaller (like 0.0001).
This makes Power BI’s internal floating math more stable and keeps entered values closer to what you expect.

Steps:

  1. Go to Modeling → New Parameter → Numeric Range

  2. Set:

    • Data type: Decimal number

    • Minimum: 0

    • Maximum: 1000

    • Increment: 0.001

    • Default: 0 (or your desired default)

This reduces the rounding error.


Option 2: Round the parameter value in a measure

If you already created the parameter and can’t change it, use ROUND() in your DAX expressions to fix the visible issue.


Example DAX:

Adjusted Parameter =
ROUND( 'Parameter'[Parameter Value], 2 )

Then use the Adjusted Paramter Measure wherever you previously used the parameter.