How to prevent my slicer to hide the items that are filtered out by a drill through

[HansWeltenV]

Hi PBI Community,

In my company I need to work by the DirectQuery mode to visualize data from the following table:

My assignment is to the following table with two slicers of it:

This page I reach by a drill through from another tab by selecting a specific Company:

Now I've been told by my customer that they want to keep all items in the top Product Category slicer visible, even if they're not available in the company by the drill through:

Not this:

but this:

 

So in the case visible above, my customer wants to see an empty table when you set the Product Category slicer to 'Cars'.

Since it's in directquery mode I can't add columns. I can only add measures. I do know that I can edit interactions between visualizations, but I can't see an option to remove the interaction between the top (Product Category) slicer and the drill through item.
I'm not able/allowed to make changes in the source file.

Can anyone help me figure out how to solve this problem?

Thanks in advance.

[amitchandak]

@HansWeltenV , Disable interactions between two slicers

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

[HansWeltenV]

Thanks for your answer and great video. 

Unfortunately this only solves a problem I had before. Now I've got the drill through filter. This way the top slicer still looses the item 'planes'. I want to keep everything visible, so the table is empty when you select planes only.

(for instance, with this drill through filter I can't find an interaction setting to the visuals)

Summary:

1 this filter applies after drill through. 

2 that causes the category slicer to loose the Planes item.(Want to see all)

3 these items have disabled the interaction with the top slicer, but that doesn't solve the problem. 

 

Any idea on how to do that?

Thanks in advance.