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

Need Help

3 Replies

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