Enable discrete values in Numeric Slicer
The new Numeric Slicer is a great addition, but there is a small issue with it that I'd like to see addressed if possible.
I have set up a table with discrete values which I am using as a basis for the slicer. In this particular case, it's a table of percentages from 0 to 0.02 in 0.0001 increments, but it could be anything really. The issue is that when moving the slider, the values that it selects are not ones in the table. So for example, selecting between 0.005 and 0.01 using the slider actually uses the values 0.00497598796 and 0.0100467686 behind the scenes. This usually works in that it gives the correct range of values, however it sometimes approximates in the wrong direction, thus missing out a value.
The worst case is when you drag the two ends of the slider together to select a single value. So selecting 0.01 should allow that value to be shown, as it is in the table, but in fact the slicer selects all values between 0.0100467686 and 0.0100467686 which means it actually selects nothing.
To me as a user, this seems illogical, although I can understand the workings behind it. So can the slicer be modified in some way to allow the selection of discrete values only?
Yes! This should be the default behavior of the slider.
It would be as simple as adding a selection in the header options menu (List, Dropdown, Between, Less than or equal to, Greater than or equal to, **Equal to**). It's essentially the same as a single selection from a list or a dropdown, it's just represented by a slider with a single movable "handle".
This is an annoying issue to deal with. My slicer will show a number on the right such as 11001, but the actually value sliced is 11000 because the value when you click on the 11001 in the slicer box is something like 11000.8232, which is an inconsistency.
I am surprised why this idea has very less upvotes, this is a basic feature even excel has.
Please support ..!!
Workaround is you can change the data type to text