Forum Discussion
Auto-generated interactive organisation chart
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 t...
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 [email protected] for a more detailed explanation.
- Stanley Chiang
Utah Department of Transportation
State of Utah