cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
obemo Frequent Visitor
Frequent Visitor

Slicer: Single value in several groups

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: 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.

1.PNG

 

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"))


2.PNG

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. 

3.png  4.PNG
  
If you have any other issue, please feel free to ask.


Best Regards,
Angelia

2 REPLIES 2
Super User
Super User

Re: Slicer: Single value in several groups

Multi-select in the slicer?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-huizhn-msft Super Contributor
Super Contributor

Re: 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.

1.PNG

 

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"))


2.PNG

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. 

3.png  4.PNG
  
If you have any other issue, please feel free to ask.


Best Regards,
Angelia