Base Slicer Selection on two columns

[Anonymous]

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	300
4	Sport		400
5	Shoes		500

Now, I have a Slicer through which I only visualise the Revenue for Products from one Category. Now I basically want to find a way to select "Sport" and visualise Product 3 and 4.

Thankful for every workaround idea!

Leon

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

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.

[Anonymous]

So that if I visualised the table, it would only be

Product ID	Category1	Category2	Revenue
3	Jackets	Sport	300
4	Sport		400