Unexpected filtering on other visual

[rode]

Hi everyone,

I have a simple model:

- Table Fact1

- Table Fact2

- Table DimCategory

- Table DimProduct.

The model has the following relations:

- DimCategory -> Fact1

- DimCategory -> Fact2

- DimProduct -> Fact2.

The first visual (Bar Cart) has DimCategory.CategoryName on the axes and a count on a field of Fact1.

The second visual (Bar Chart) has DimProduct.ProductName on the axes ad a count on a field of Fact2.

The first visual has the filtering interaction to the second one.

So, now I can see "Category A" on first chart and three different products on the second chart (which belong to the same category "Category A").

But if I select the bar on the first chart, only one product is shown in the second visual (even if the other two belogn to the same category too). Why does this happen? How can I avoid this misunderstanging behaviour?

Thanks,
Regards.

[v-chuncz-msft]

@rode,

You may check if a product belongs to multiple categories.

[rode · Accepted solution]

Hi @v-chuncz-msft and thank you su much for your answer.

The product doesn't belong to many categories.

Nevertheless, I've find out what the problem is. The first visual had a filter on time dimension (which filters both fact tables), while the second visual doesn't have it. So, when I filter from the first chart, this time filter is propagated to second one and two products disappear.

Regards.