numeric range not showing exact entered value

Anonymous — Mon, 24 Jun 2024 09:31:52 GMT

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?

Re: numeric range not showing exact entered value

Anonymous — Tue, 25 Jun 2024 09:00:01 GMT

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.

topic numeric range not showing exact entered value in DAX Commands and Tips

numeric range not showing exact entered value

Re: numeric range not showing exact entered value