Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |