Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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
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)
There are a couple of custom Network Graph visuals available. Pick one you like.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |