numeric range not showing exact entered value

[hussein_c]

hey everyone, i am using a numeric range from 0 - 1M, with a single value input. when i enter a specific value, in my case 865,294, the field generates another value (865,135) than the one i enter. i knew that numeric range fields can only take up to 1002 unique values, so i know that my option is to either use a 1000 increment or using the between format instead of single value. is it possible for me to be able to use the between format, only that when i enter 1 value, the other is equal to it, and by that i hide 1 of the 2 values so that it could act as a single value format?

value that i inputvalue that i get

[Anonymous]

Hi @hussein_c ,

The results of the test say that it won't work for a while. Even if you change the units to none. it still shows the nearest integer.

You can refer to below document:

Create a numeric or date range slicer in Power BI - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.