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.
v-juanli-msft
Community Support
Community SupportHi 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