Forum Discussion
Slicer to include or exclude rows with specific text
Hello,
I have the following table and i am trying to make a slicer that would show a checkbox with the two options: "Yes" or "No". The selection in the checkbox would either show all rows including, otherwise excluding the text "not received _ no group", respectively. Is that possible? Any help is much appreciated!
| Document ID | Amount | Received date | Text |
| 24897 | 3989 | 06/07/2022 | not received _ no group |
| 27387 | 1781 | 07/07/2022 | not received _ no group |
| 25119 | 4510 | 06/07/2022 | cleared |
| 25406 | 6467 | 05/07/2022 | not received _ no group |
| 24924 | 6570 | 05/07/2022 | not received _ no group |
| 24893 | 4437 | 06/07/2022 | received _ pending |
| 25403 | 6554 | 05/07/2022 | received _ pending |
| 24845 | 6408 | 05/07/2022 | not received _ no group |
| 24924 | 7049 | 06/07/2022 | cleared |
| 24618 | 6411 | 05/07/2022 | cleared |
| 24622 | 4413 | 05/07/2022 | cleared |
| 24891 | 4372 | 05/07/2022 | not received _ no group |
| 24891 | 6729 | 05/07/2022 | cleared |
| 24925 | 6770 | 05/07/2022 | recorded in advance |
| 27415 | 6548 | 05/07/2022 | recorded in advance |
| 27415 | 6414 | 05/07/2022 | recorded in advance |
| 27415 | 6450 | 05/07/2022 | not received _ no group |
| 27415 | 6544 | 05/07/2022 | cleared |
| 27415 | 6546 | 05/07/2022 | invoiced |
| 27415 | 6583 | 05/07/2022 | invoiced |
| 27415 | 6615 | 05/07/2022 | recorded in advance |
Hi Anonymous
You can create a calculated column that you can then use for the slicer. Just create a conditional formula to use in the calculated column like the following:
Slicer =
SWITCH (
TRUE () ,
'Table'[Text] = "not received _ no group" , "Yes" ,
"No"
)You can then use the new calculated column to create the Slicer you want 🙂
Hope this helps!
Theo
5 Replies
Hi Anonymous
You can create a calculated column that you can then use for the slicer. Just create a conditional formula to use in the calculated column like the following:
Slicer =
SWITCH (
TRUE () ,
'Table'[Text] = "not received _ no group" , "Yes" ,
"No"
)You can then use the new calculated column to create the Slicer you want 🙂
Hope this helps!
Theo
TheoC Thanks for your reply! Is it possible to add a third option to the slicer: "Show all" where the slicer would have no effect, that is, it will show all rows and not filter anything?
Hi Anonymous you can do this by clicking on the actual Slicer visual and using the options to "select all". Hopefully this is what you're after.