Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter/slicer with 2 values on the same columns

Hi All,   I am trying to create slicer on same column whihc will have 2 types of data - please find below more details      
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Column 2 of Table2 should have Fruit or City depending upon the entry in column A.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Thanks for your response here is the screen please have a look :

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    In Data2 column of Table2, the entries should be Fruit, City, Fruit, City, City, Fruit, Fruit, City.  Create a slicer from this column.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       Hi,

       

      Thanks for your update. 

      please see below requirement : Slicer should have 2 values - 1. fruit 2. All

      if i select fruit - it will pull only fruits and if i selct All it should have fruit and remaining values as well.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        For All, you just leave all slicer boxes unchecked.  Simple.