Single Value Slicer created from Parameter keeps rounding my manual inputs

[mrothschild]

PBIX file: https://drive.google.com/file/d/1j_4CrUj0fPh0xK6hnO7OZ-uIWkoP5Kdg/view?usp=sharing

I created a New Parameter that ranges from -1 to 1 with an increment of 0.001

From that, I switch the slicer to a Single Value for user to input, but every time it happens, the number defaults/reverts to a figure that's close to but not precisely.

Any help would be appreciated!

When I enter: 0.05 

PowerBI decreases to 0.0509

[mrothschild · Accepted solution]

The workaround to fix this is to use Whole Numbers and then custom format the number by pasting the following into the Format field under the Column Tools menu item:

0.#\%;(0.#\%)

[amitchandak]

@mrothschild , I think this is because of what if approximation, try to check if you can get the correct value using a slider. also, keep the value as 3 decimal places.

[mrothschild]

If I change to a "Between" slicer, I can input the precise number.  With a Single Value, even with the slider, it still is forcing more significant digits than I'm asking of it.