Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 input
value that i get
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
19 | |
17 | |
12 | |
9 | |
9 |