Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.#\%)
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.#\%)
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |