Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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,...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous you can just tick "Single Select" from the options. There is no need for additional formulas etc.

 

Hope that helps.