object with multiple relations to other objects

[Norbertus123]

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

[Norbertus123]

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?

[lbendlin]

Is your data representing a true hierarchical tree graph or a direct acyclical graph ? Can an employee have more than one manager?

[Norbertus123]

Hi @lbendlin 
In practice, it will come down to me that it is an acyclical model. 

[lbendlin]

Don't have a solution but here is an article that may interest you.

https://www.sqlservercentral.com/articles/dijkstras-algorithm

[Norbertus123]

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)

[lbendlin]

There are a couple of custom Network Graph visuals available. Pick one you like.