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,

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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    To achieve this 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.

     

    Please follow steps below:

    Based on my previous post, we have Table1 and Table2,

    Besides all in my previous post,

    create a new table without any relationship with other tables

    Table3

     

    Add [category_fruit] in the slicer

    Create measures in Table1

    isfiltered = ISFILTERED(Table3[category_fruit])

selected value = SELECTEDVALUE(Table3[category_fruit])

flag = IF([isfiltered]=TRUE(),IF([selected value]=MAX(Table2[category]),1,0),1)

    Add [flag] in the visual level filter

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.