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

marcelsmaglhaes's avatar
marcelsmaglhaes
Super User
9 months ago

Hey Pra2010Gha 

It sounds like Power BI is misinterpreting the decimal values due to regional settings. For example, when you enter 45.67 and it shows 45.94, it's likely treating the input incorrectly because of the decimal separator.

Since your increment is set to .01, make sure you're entering numbers using a dot (.) as the decimal separator, like 1000.00 instead of 1000. Also, double-check that your regional settings are setting correctly, so Power BI interprets the values as expected.


Try that and let me know if works. 

Edited: If didn't work, try look at Solved: Parameter (decimal) resolving to incorrect value - Microsoft Fabric Community