Slicer: Single value in several groups

[obemo]

Hey all, 

I have a slicer with 3 options - Blank, <100 and >100. 

If <100 is chosen I want the table to show me the records for both Blank and <100. 
And for >100 I want both Blank and >100. 

This could be done by grouping the values, if it weren't for the values disappearing from the selectable values when already grouped. 

Any ideas for another solution?

[silpai]

I have a similar issue. I want to group same provinces  into multiple regions and also see their results individually so I can use a single filter.

Province Column - New Brunswick, Nova Scotia,  St. John's and PEI

Groups:

Maritimes = New Brunswick/ Nova Scotia/ PEI

Atlantic=New Brunswick/ Nova Scotia/  St. John's/PEI

New Brunswick

 Nova Scotia

 St. John's

PEI

How do I create this custom query??

[v-huizhn-msft · Accepted solution]

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

[Greg_Deckler]

Multi-select in the slicer?