- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Interactions on Power BI Desktop not working
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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"

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-27-2024 07:31 PM | |||
06-12-2024 01:54 AM | |||
05-21-2024 07:43 AM | |||
04-23-2024 01:45 AM | |||
Anonymous
| 07-30-2024 12:31 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |