Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Norbertus123
Frequent Visitor

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 ObjectTitle
AAA
BBB
CCC
DDD
EEE
FFF
GGG
HHH


Relation table: 

ID RelationFrom ID ObjectTo ID Object
1AB
2AG
3BC
4GC
5CH

 

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

Norbertus123_0-1703255919342.png


Can someone help to solve this question?

Thanks a lot, Norbertus

6 REPLIES 6
Norbertus123
Frequent Visitor

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. 

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

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

 

Norbertus123
Frequent Visitor

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
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.