Filtering for values outside of a specific range

[Anonymous]

Hi,

Is it possible to dynamically filter on a visual so that it only shows values larger than say $10 and values less than -$10 (i.e exclude all values between -$10 and +$10)? I know I can do so on the filters on the side (see screenshot below), but I would like to be able to be able to do this with a slicer.

Thank you,

Nathan

[Anonymous]

@Anonymous Please try creating a calculated column as below.

Column = IF(OR('Table'[Spot Capital]>=10,'Table'[Spot Capital]<=-10),TRUE(),FALSE())

Please share some sample data if it doesn't work for you and in case it helps accept solution 

[Anonymous]

@Anonymous Thank you for the response, however I would like the end user of this report to be able to change the $10 and -$10 limit dynamically to whatever value they wish. 

i.e. In the screenshot below, I would like the end user to be able to move the slider and instead of filtering for values between the 2 numbers, filter for values outside of it (greater than 10 and less than -10)

Thanks you,

Nathan

[Anonymous]

@Anonymous Please create a parameter and then use that parameter as slicer

After creating parameter create following measure

Measure = 
VAR _min = MIN(Parameter[Parameter])
VAR _max = MAX(Parameter[Parameter])
RETURN IF(OR(MAX('Table'[Spot Capital])>=_max,MAX('Table'[Spot Capital])<=_min),1,0)

Now select the visual and click on measure in filter pane. Adjust it to show item when the value is 1.