Forum Discussion
Hierarchy
Following the steps in the link, didn't quite return the results needed. My table has the following columns:
User - all people in the company
User Manager Name - the manager for each user
User Managers Name - the manager of the manager
How do I flatten the data so that I can account for 5 levels of our org structure. I need to be able to drill down from the SVP, which for some users that could be the Manager Name, but for others it could be User Manager Name.
I don't know Power BI very well, so if there are any specific suggestions that could help, I'd appreciate it.
Hi,
In the Query Editor, select all columns other than the 3. Right click and select "Unpivot Other Columns".
Below is a sample of the data. Ultimately, I need a visual starting at CEO Sparks and be able to drill down into each Manager to the User level.
Manager's Manager Level 1 Manager User Training Title
Scott, Angela Davis, Ryan Albert D. Training 1
Scott, Angela Davis, Ryan Albert D. Training 2
Rodes, Jason Rider, Jeffrey Ally, Sarah Training 1
Rodes, Jason Rider, Jeffrey Ally, Sarah Training 2
Rodes, Jason Rider, Jeffrey Ally, Sarah Training 3
Turner, Jake Scott, Angela Davis, Ryan Training 1
Turner, Jake Scott, Angela Davis, Ryan Training 2
CEO Sparks Davis, Alex Turner, Jake Training 1
Davis, Alex Turner, Jake Scott, Angela Training 1
Follow the method which i suggested in my previous post.