Need a slicer that's opposite of "between"

[Anonymous]

I need a slicer that has the opposite effect of the "between" slicer setting.

Something like this:

When the buttons are slid to, for example, 1,16 and 1,17, I want to see all the correspondig data for the values 1,14 - 1,15 and 1,18.

The use case is for machine data that was collected, and data that either falls under or exceeds certain limits should be able to be filtered out.

Is there a possibility to implement this? Doesn't have to be visualized as a slider like above, of course.

[v-xinruzhu-msft · Accepted solution]

Hi @Anonymous 

You can not set the opposite slicer, but you can refet to the following solution to replace it.

Slicer table

Sample data 

You can create a measure to contro display the opposite of the slicer and put it to the visual filter

Measure =
VAR a =
    ALL ( Parameter[Parameter] )
VAR b =
    EXCEPT ( a, VALUES ( Parameter[Parameter] ) )
RETURN
    IF ( COUNTROWS ( FILTER ( 'Table', [Value] IN b ) ) > 0, 1, 0 )

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chonchar]

@Anonymous 
Try this. You can find it under the filters on this visual pane. 

@ me if this doesn't work for you. 

Best of luck,

Cam