Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

numeric range not showing exact entered value

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    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.