Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |