Numeric range slicer and Measures

Hi SPC_123 ,

Theres is an alternative with disconnect tables.

Let's assume that you want to filter out all the information based on 3 ranges of values:

Know you use the range column as your slicer and then make the following measure:

Slicer Measure = IF([Measure]>=MIN(Range_Slicer[Min]) && [Measure]<=MAX(Range_Slicer[Max]); 1 ;BLANK())

Then place this measure on the filters of the visualizaition and choose is not blank. that will filter out the visualization accordingly to your selection.

If you want to have the range slicer then create a table with values using:

Table 2 = GENERATESERIES(1;30;1)

And your measure should be:

Slicer Measure _limits = IF([Measure]>=MIN('Table 2'[Value]) && [Measure]<=MAX('Table 2'[Value]); 1 ;BLANK())

The use this measure to filter out the table again choose different from blanks.

Check PBIX file attach.