Forum Discussion
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...
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
MaggieCommunity 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.
So that if I visualised the table, it would only be
| Product ID | Category1 | Category2 | Revenue |
| 3 | Jackets | Sport | 300 |
| 4 | Sport | 400 |