Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
67 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |