Slicer: Single value in several groups

Hi obemo,

The slicer is used to filter the row in table. If you want to get the same Blank records when you choose <100 or >100, we are not able to achieve it. The different values in slicer will filter different records. For your requirement, you’d better create a calculated column to identify the value, then select it in slicer. I try to reproduce your scenario and get the expected result.

I create the sample data table.

Create a calculated column using the formula and get the result shown in screenshot below.

Signal = IF(Test[Value]>=100,">=100",IF(ISBLANK(Test[Value]),"Blank","<100"))

Create a slicer using the “Signal” field, create a table using “Value” field. If <100 is chosen, the table shows the records less than 100. And for >=100,  it return all the records greater than and equal to 100. And for blank, it displays all the blank records. 

 
  
If you have any other issue, please feel free to ask.

Best Regards,
Angelia