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 | 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
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.
3 Replies
v-juanli-msftCommunity Support
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
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