Forum Discussion
Slicer creates non-existent numeric range
- 4 years ago
Hi, Belforen
It is a default behavior of range slicer especially when you choose Between. It will generate a continuous sequence of ranges between min date(numeric) and max date(numeric) of the column.
eg:
Even though non-existent sequence values are generated on the slicer, you still get the correct filtering results since there are no such values actually in your table.
If you don't want to see non-existent values on the slicer, then avoid using the between option or change the type of the field to a non-numeric type, it is worth noting that the between option cannot be used even after changing the type.
Although the slicer looks less than ideal it still gives correct filtering results, if you insist you can use the above mentioned approach.Hope this helps.
refer:
Numeric Slicer showing values outside of dataset
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.