How to make 2 dimension table interact with each other

[spagad6263]

Hi,

I have 3 tables below and relationship is from left to right as 1:n. 

Product Category >> Product Subcategory >> Product

When I select a category, only the relevant subcategories will stay. What I would like to see is when I select a subcategory, only the related categories will be left on the slicers below. I've check the Format >> Edit Interaction, but it doesn't quite work. Any suggestions? Thanks

[Uzi2019]

Hi @spagad6263 
How did you join it ?? 
can you take the same data in one filter just to check whether subcategories is properly mapped under category?

[Jihwan_Kim · Accepted solution]

Hi,

One of ways is to create a measure and put it into visual level filter pane and configure it as "is not blank".

Please check the below picture and the attached pbix file.