Forum Discussion
Custom Slicer (everything vs everything except 1)
Hello smart peope out there.
I am stuck with this problem and need some help. I try to use a simple example:
I want to enable the user to choose between two baskets.
One basket has all products and the other all except one.
At first, I made a slicer on product and set bookmarks. The problem is, that when the user switches to another page, the bookmark does not transfer. Thus he/she would have to chose again the basket for which the values are shown.
Thus I want to create a real slicer with the options Basket 1/ Basket 2.
The data looks the following:
| Product | Basket 1 | Basket 2 |
| A | yes | yes |
| B | yes | yes |
| C | yes | yes |
| D | yes | yes |
| E | no | yes |
Can you help me with this?
Kind regards
Hi Anonymous ,
According to your description, here's my solution.
1.Create a new table. Make relationship between the two tables and select the filter direction to Both.
2.Put the Basket column in the slicer, it will filter the Product column from the original table.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- edhans
Community Champion
If you want slicers on different pages to have the same selections, use the Sync Slicers feature. The bookmarks would then effectively work across pages. When you set your bookmarks, disable the "current page" setting. That way they can click a button on Page 4 to activate a bookmark. It will set the values of the slicer for Page 1, and the slicer on Page 4 would sync to that value.
thanks for your reply.
I already tried this. The problem with it is - speaking in the basket context -if i show basket 2 on default, then click on the bookmark button on page 4 to show the other basket (basket 1) - page 4 and page 5 will show the chosen basket 1. So far so good. But, the same bookmark button on page 5 will not look activated. Thus the user will think, that basket 2 is still shown, while values for basket 1 are shown in fact.
Thus, to create a real slicer out of the data above would be better. I think - but I am open for any suggestion 🙂
v-yanjiang-msftCommunity Support
Hi Anonymous ,
According to your description, here's my solution.
1.Create a new table. Make relationship between the two tables and select the filter direction to Both.
2.Put the Basket column in the slicer, it will filter the Product column from the original table.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
