Custom Slicer (everything vs everything except 1)

[Anonymous]

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

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

great! That's such an easy but effective solution! Thanks a lot for helping me out 🙂
Kind regards,

lece

[edhans]

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.

Slicers in Power BI - Power BI | Microsoft Docs

[Anonymous]

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 🙂