Help with Full Primary Slicer and limited secondary slicer

[mish_akopyan]

Hi Guys! I am looking for some magic and hope one of you might have the spell! 

Please take a look at the pic below. 

Customer ID would be the primary slicer and Product type would be the secondary slicer. 

Does anyone know how I could build a slicer in Power BI where... if I click on customer 2, the product 2 would be hidden from slicer view? But if I were to click on customer 1 or 3 then I would be able to see products 1 and 2?

Thank you in advance!!

[v-jingzhang · Accepted solution]

Hi @mish_akopyan 

You could create below measure, use it as a visual-level filter of the Product Type slicer and set value is 1.

Flag = 
IF (
    SELECTEDVALUE ( 'Table'[Customer ID] ) = "Customer 2",
    IF ( SELECTEDVALUE ( 'Table'[Product Type] ) = "Product 2", 0, 1 ),
    1
)

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[mish_akopyan]

@v-jingzhang This might be it. I will give it a test run and let you know! much appreciate it!

[v-jingzhang]

Hi @mish_akopyan 

Does my reply solve your problem? If yes, kindly accept it as the solution. Otherwise, please provide more details about your problem so that we can work on it further. Thanks.

Regards,
Community Support Team _ Jing

[marcl1]

In your table you build a measure : BiDirectional = calculate(sum(sales)) and then in both slicers you filter in the filter panel by putting BiDirectional is not 0 and it should work 🙂

[amitchandak]

@mish_akopyan , I doubt you can hide a slicer with help from another slicer. You can do that with a bookmark. which seem less suitable for this purpose

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[mish_akopyan]

@amitchandak Thank you for the response! So if you cannot hide the slicer. can you completely disable it? for only customer 2?