Forum Discussion
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 ...
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 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.