Slicer to filter multiple measures based on value

[Anonymous]

Hi everyone! 

I have a problem which I'm not super sure how to solve.

I would like to create a slicer that contains a range of percentages OR has the ability to say "show all values greater than 100%" (as an example). This slicer would essentially filter the "Trailing 13-Week Delta" measure shown in the screenshot below. For example, if the slicer is set to show all "Trailing 13-Week Delta" values that fall between 100% - 600%, the rows in the table would automatically filter.

The other columns shown in the screenshot are all separate measures. Is there any solution that would work to filter the rows in the table based on the percentage?

[jdbuchanan71 · Accepted solution]

@Anonymous 

You can add a paramater slicer to your report which will give you the slider.  Not sure of your max range but in my example I went from -200% to 600% in 10% increments.

Format the field as %

Then you write a measure to compare your [Trailing 13 week delta] measure to the slicer selection.

Filter Measure = 
VAR _Selection = SELECTEDVALUE('Filter %'[Parameter])
RETURN 
IF ( [Trailing 13 week delta] >= _Selection, 1 )

It will read the slicer and return a 1 if the [Trailing 13 week delta] is >= the selection and a blank if it is < the selection.

Then you add that measure as a filter on your table visual and set it to 'Is not blank'

I have attached my sample file for you to look at.

[Anonymous]

Thank you so much! This worked really well!!