Forum Discussion
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?
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
3 Replies
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??
Multi-select in the slicer?
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
