Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filtering for values outside of a specific range

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.