Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Base Slicer Selection on two columns

Hello,   I've got following problem:   I have a table that looks a bit like this: Product ID Category1 Category2 Revenue 1 Dresses   100 2 Dresses   200 3 Jackets Sport 3...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Go to Edit queries,

    create a duplicate table Table2,

    In Table2, unpivot columns "category 1" and ""category 2",

    filter "Value" column to remove empty,

    close&&apply.

     

    Create relationship between Table1 and Table2 on "Product ID"

    Add "value" from Table2 in a slicer.

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Go to Edit queries,

create a duplicate table Table2,

In Table2, unpivot columns "category 1" and ""category 2",

filter "Value" column to remove empty,

close&&apply.

 

Create relationship between Table1 and Table2 on "Product ID"

Add "value" from Table2 in a slicer.

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.