Forum Discussion
Slicer to include or exclude rows with specific text
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?
Community ChampionHi 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.
TheoC Thanks for this suggestion but i would like to keep it as a simple single-click checkbox selection list. The issue with the "Select all" option is that if it is selected, then if another option is selected, then it actually excludes the latter instead of moving to that selection only.
For example, after clicking on the "Select all" option:
Then, if the option "No" is clicked, instead of selecting only "No", it actually excludes it:
So, i think maybe having an option in the formula where it would do the same as "Select all" or select none. Is that possible?
- TheoC
Hi Anonymous you can just tick "Single Select" from the options. There is no need for additional formulas etc.
Hope that helps.