Filter Visuals based on the min and max value selected in a slicer

[LamSar]

Good morning,

I have a question.

I have this report:

I created an indenpendent slicer with values from -100% and 100%, with this formula:

GENERATESERIES(-1,1.01,0.01)

The goal:

Showing only the values in the table visual and card visual,  where the deviation of the average weight vs. the weight is between the min and max values of the slicer selection (in this case -20% and +20%).

Any ideas on how to achieve this?

[andhiii079845]

Do you mean the difference (last column) should be between -20,00 % and 20,00 %? 

[LamSar]

No, I just created the last column to check the difference %.

In the final report, this column will not be visible.

In the final report there will be two colums, average weight and weight. So these columns should be filtered with selected values in the slicer.