Cascading filters

[yfontes]

Hi,

I'm new with Power BI. I'm trying to do a cascading filter with Category -> Product. When I select the first filter, values in the second filter change automatically and then, I select the value in the second filter list.  Everything goes like expected until now. However, when I select another value in the first filter, my second filter selection still there, even though it not belong to the category in the new first list selection.

I would expect that when I selected another value in the first filter, the second filter list would be updated based on this new first list selection AND the previous second list selection would be cleaned. What am I doing wrong?

Here what's hapenning:

[amitchandak]

@yfontes , Option 1 - Make join as bi-directional

or create a measure on many side table

m1= count(AW_productos_subcategory])

and use that as visual-level filter AW_productos_category filter check for non blank