Forum Discussion
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...
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
Same problem here. I'm trying to set the slicer state with decimal numbers #.00, and facing the same problem