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 all, I'd been tasked to modernize my organisations map of the different branches/ factions.
I can extract all the data from our sharepoint but I'm curious on how to utilize it best.
I'd like to have like a tree laid out in a hierarchy form with each image being interactive and linked to a sub-site with more information of that branch/faction.
Is this something PowerBI can make or do I need some other office365 software?
Regards
We created an org chart using the standard Power BI Matrix visual. Data resides in a standard RDBMS single table in a parent-child (supervisor-subordinate) style. Write a recursive SQL query to query all the hierarchy levels and put it into a matrix like this:
https://www.udot.utah.gov/connect/about-us/department-organizational-chart/
email schiang@utah.gov for a more detailed explanation.
- Stanley Chiang
Utah Department of Transportation
State of Utah
Hi, thank you very much for the reply.
However, I have an org of more than 700 ppl. How could that be displayed properly on the visual? I found the canvas is just tooooooooooo small for displaying even level 2 mgrs. There are about 8 levels in total. Also anyway I could search for an emplyee?
If anyone could help, that would be deeply appreciated!
User | Count |
---|---|
85 | |
76 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |