Forum Discussion
Bi-directional filtering with different columns for each direction?
Hello all, I have a question about bi-directionally filtering two tables with different columns based on the direction.
Say this is Person Table:
| Id | Name |
| 1 | John |
| 2 | Paul |
| 3 | John Jr. |
| 4 | Paul Jr. |
Say this is Child Table:
| Id | ParentId | Name |
| 3 | 1 | John Jr. |
| 4 | 2 | Paul Jr. |
The functionality I want is when I click a row in the Person Table then it will get all of their children (Id -> ParentId) in the Child Table. This can be done with a one-to-many (there could be multiple children) single directional relationship from the Person Table to the Child Table.
However, I also want a functionality of, when clicking a row in the Child Table, it gets that person (Id -> Id) in the Person Table. This can be done by with a one-to-one single directional relationship from the Child Table to the Person Table.
The problem I'm having is PowerBI isn't letting me put two relationships, even though they are going opposite ways, onto the two data models. I also can't just have one relationship that is bi-directional because I am filtering on different columns depending on the direction. The whole point of this is so that I can click a Parent in the Person Table, have their children pop up in the Child Table, and then I can click a Child in the Child Table and it will select that Child in the Person Table.
Any help or a different approach would be appreciated, thank you!
2 Replies
- lbendlin
Super User
However, I also want a functionality of, when clicking a row in the Child Table, it gets that person (Id -> Id) in the Person TableWhat for? You already have the Id from the join field?
then I can click a Child in the Child Table and it will select that Child in the Person TablePlease define what you mean by "select"
lbendlin wrote:However, I also want a functionality of, when clicking a row in the Child Table, it gets that person (Id -> Id) in the Person TableWhat for? You already have the Id from the join field?
then I can click a Child in the Child Table and it will select that Child in the Person TablePlease define what you mean by "select"
The Person Tables and Child tables have unique columns.
My apologies, when I say both "getting" and "selecting" I'm referring to clicking rows in the visual PowerBI tables. I want to be able to click a row in the Person Table and have it select a row in the Child Table (through the Id -> ParentId relatinship). Then, inside the visual PowerBI Child Table, I want to be able to click that child row and have it select (highlight, get, show, whatever you want to call it) a row in the visual Person Table (through the relationship Id -> Id).
So this effectively means I'm transitioning my mouse selection, in the visual tables, from the parent's row in the Person Table and then I click the child's row in the Child Table and it shows that child row in the Person table.
Heres a visual example for you of the mouse clicks/selections I want to have:
CLICK 1
Say this is the Person Table:
Id Name 1 John 2 Paul 3 John Jr. 4 Paul Jr. This is the Child Table after that click:
Id ParentId Name 4 2 Paul Jr. CLICK 2:
Say this is the Child Table:
Id ParentId Name 4 2 Paul Jr. This is the Person Table after that click:
Id Name 4 Paul Jr.
