How to prevent my slicer to hide the items that are filtered out by another slicer?

[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:

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 selected company:

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'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.

P.S. Above is a simplified example, in reality this list consists of more companies and a total of more than 10K products.

 

 

[HansWeltenV]

This works great.
Now I've got a further question. Besides the interaction between visuals, how to change the interaction of a visual (same slicer in this case) when you reach this tab by drill through (that filters it to one item of "company").
I tried selecting the drill through filter and see if I could change the relation of that slicer to it, but with the drill through I don't see any edit interactions option.

Thanks in advance!

[HansWeltenV]

I added this as a separate item:

https://community.fabric.microsoft.com/t5/Desktop/How-to-prevent-my-slicer-to-hide-the-items-that-ar...

[HansWeltenV]

Great!  That seems like it should work. I'll try it tomorrow. 

Thanks!

[Ritaf1983 · Accepted solution]

Hi @HansWeltenV 
You can manipulate your slicers with format options from the report view.
Follow these steps:

1. Select your first slicer (company name in your case) + in format options click on "edit interactions":

2. Turn off the filtering option:

Result of Selecting category and subcategory which not exists

Link for sample file: Here 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly