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

v-achippa's avatar
v-achippa
Community Support
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

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

Hi @Pra2010Gha,

 

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