Forum Discussion
object with multiple relations to other objects
Hi,
i have a table "Object"with unique ID. They have a relation to other object with is defined in a seperate table "Relations"
now i want to make insigts how the object are related to each other
Example =>
Object table:
| ID Object | Title |
| A | AA |
| B | BB |
| C | CC |
| D | DD |
| E | EE |
| F | FF |
| G | GG |
| H | HH |
Relation table:
| ID Relation | From ID Object | To ID Object |
| 1 | A | B |
| 2 | A | G |
| 3 | B | C |
| 4 | G | C |
| 5 | C | H |
For example i want to show that Object A
* is connected to object A => B => C => H
* is connected to object A => G => C => H
Can someone help to solve this question?
Thanks a lot, Norbertus
6 Replies
There are a couple of custom Network Graph visuals available. Pick one you like.
Hi, i don't think think a custom visual is the only solution.
An Object have for example a status ( Green, Red).
Now i want to make visable the status of an object with
- Direct Relation ( A to B)- Indirect Relation ( A to C)
When I select object A then i want to know is there a related object with the status "Red" (Direct and Indirect)
Hi,
i don't have the solution yet,
first part of this article helps a lot GRAPH THEORY IN POWER BI | Blog | FreshBI
So i have the indirect relationships on my path as well
Perhaps i can describe my question in another way:I have a table with employees and managers. This structure have several hierarchical levels.
Now i want to know when I select a manager, how many employees have birthdays today in the entire child parent hierarchy?Is your data representing a true hierarchical tree graph or a direct acyclical graph ? Can an employee have more than one manager?
Hi lbendlin
In practice, it will come down to me that it is an acyclical model.
