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

Pra2010Gha's avatar
Pra2010Gha
Helper I
9 months ago

so what should be the regional settings to interpret it correctly?

Also, I am entering the value with decimal seperator like 45.67 and not 45

v-achippa's avatar
v-achippa
Community Support
9 months ago

Hi Pra2010Gha,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you marcelsmaglhaesand gmsamborn for the prompt response.

 

This issue happens because the parameter or slicer is trying to handle too many discrete numeric values. When the range is large and the increment is very small like for example 0 -1000 with a 0.01 step, power bi automatically samples or like snaps the available values into a smaller set of ticks. That causes the entered decimal to round to the nearest tick, which is why a value like 45.67 shows as 45.94.

  • Increase the increment for example like to 0.1 or reduce the range so that there are fewer discrete values.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    9 months ago

    Hi Pra2010Gha,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa