Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 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 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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |