Andrew Kay on 02 Aug 2018 21:52:03
The Numeric Range Slicer allows you to use Between, Before, After, List, Dropdown and Relative. But I feel like one obvious option is missing; 'Equal to' or 'Equals'.
Dropdown and List have the problem of needing to scroll through all values to reach the one you're after - so the closest you can get is to use Between and put the same value in both boxes, but this isn't particularly user friendly and seems a little silly when we're explaining it to end users.
Could we add an 'Equals' option to Numeric Range Slicers?
- Comments (2)
RE: Numeric Range Slicer - Equals
Definitely need a Numeric Equals to option...
RE: Numeric Range Slicer - Equals
Folks, this is really a very popular use case. Many companies need far more flexibility than What If Parameter offers. The way to achieve it is to create a disconnected table with a simple Slicer on top and a SELECTEDVALUE () measure created that uses the results of that selection. The problem is - if it's a list of numeric values, there is no "equals" option, so there goes another workaround of using less than or equal to and then covering the grayed out box with some additional text box visuals, instead of just having the functionality of adding it right into the Slicer. Please consider adding this vital feature to the Slicer visual. Thanks!