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

gmsamborn's avatar
gmsamborn
Super User
9 months ago

Hi Pra2010Gha 

 

I'm not sure but I think the problem might have to do with the number of discrete values in your slicer.

I've run into this in the past and it appears you want to have 100,000 discrete numbers in the slicer.   

I can't remember the actual number but different visuals (including slicers) have actual limits, and that once that limit is broken, sampling occurs.

 

Once sampling occurs, it would look exactly like what you are seeing.

 

I wish I still had the link.

 

Hopefully this helps.  (Maybe AI could help with the limits for the relevant visuals.)

 

 

  • Pra2010Gha's avatar
    Pra2010Gha
    Helper I
    9 months ago

    What link are you talking about?How did you manage?