Forum Discussion

Pra2010Gha's avatar
Pra2010Gha
Icon for Helper I rankHelper I
10 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

lsilvestre's avatar
lsilvestre
New Member
10 months ago

Same problem here. I'm trying to set the slicer state with decimal numbers #.00, and facing the same problem