Interactions on Power BI Desktop not working

[Ricardo77]

Hello,

i've got a report where i show 3 tables: A) contract header -> B) line contract -> C) invoices , related using 1:n from "left to right".

A contract can have multiple lines, and each line can have multiple invoices related

In the canvas, they are displayed like this:

A 

B

C

... where the interactions are: 

A can only change B
B can only change C

But the result, is, when i select a line of B, i change the filters on A, so in fact, "B changes C but also changes A"

Could this be a Power BI glitch? Or am I missing something here.

Regards

[Ricardo77]

Hello, 

thanks for your answers, but in fact it doesn't work, it should be related with one of the points mentioned by @lbendlin , to whom i left a kudos.

Thanks

[Anonymous]

@Ricardo77 
Make sure you have single direction relationship between A> B>C. With my test, this kind of relationship should interact as you expected.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

It depends.

It depends on the order of the fields in your visual. It depends on which table you took the field from. It depends on you enabling/disabling "Show items with no data".  And it also depends on the data model phenomenon called "Auto exist"

Understanding DAX Auto-Exist - SQLBI