Skip to main content
Microsoft Idea

Power BI

Needs Votes

Enable discrete values in Numeric Slicer

Vote (36) Share
Duncan Pryde's profile image

Duncan Pryde on 03 Apr 2017 15:16:43

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?

Comments (5)
Duncan Pryde's profile image Profile Picture

Power BI User on 05 Jul 2020 23:57:01

RE: Enable discrete values in Numeric Slicer

Yes! This should be the default behavior of the slider.

Duncan Pryde's profile image Profile Picture

Power BI User on 05 Jul 2020 23:28:20

RE: Enable discrete values in Numeric Slicer

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".

Duncan Pryde's profile image Profile Picture

Jesse Liston on 05 Jul 2020 22:54:31

RE: Enable discrete values in Numeric Slicer

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.

Duncan Pryde's profile image Profile Picture

koushik on 05 Jul 2020 22:51:12

RE: Enable discrete values in Numeric Slicer

I am surprised why this idea has very less upvotes, this is a basic feature even excel has.

Please support ..!!

Duncan Pryde's profile image Profile Picture

Power BI User on 05 Jul 2020 22:46:06

RE: Enable discrete values in Numeric Slicer

Workaround is you can change the data type to text