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 guys, totally new to PowerBI and despite some hefty Googling I cannot work out if it can do what I am hoping it can do.
We monitor our teams and vacancies using Excel right now, in a table like this:
NAME: LEVEL: ROLE: MANAGER:
Tom | Director | Account Owner | NA |
Sarah | Senior Manager | Stakeholder Lead | Tom |
Tim | Manager | Stakeholder Manager | Sarah |
Steve | Senior Manager | Compliance Lead | Tom |
Sue | Senior Manager | Project Lead | Tom |
Paul | Manager | Project Manager | Sue |
VACANCY | Manager | Project Manager | Sue |
VACANCY | Senior Manager | Programme Lead | Tom |
My question is... can Power BI represent this visually, automatically, in the same way you might be able to create a hierarchy Smart Art structure in PowerPoint.
If so, I don't need detail, I can learn that in my own time, but a rough idea of how to structure it would be really useful. Thanks!
Solved! Go to Solution.
Please consider the hierarchy tree visual, the effect is like this:
You can click the '...' in the Visualizations pane, and search for it.
This link may help:
xViz Hierarchy Tree/Advanced Decomposition Tree - Power BI Visual
Here are some links for your reference:
Solved: How to Create Organization Chart in Power BI Deskt... - Microsoft Fabric Community
Create a hierarchy - Microsoft Support
Create visuals with PowerPoint SmartArt for Power BI - BI Samurai
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please consider the hierarchy tree visual, the effect is like this:
You can click the '...' in the Visualizations pane, and search for it.
This link may help:
xViz Hierarchy Tree/Advanced Decomposition Tree - Power BI Visual
Here are some links for your reference:
Solved: How to Create Organization Chart in Power BI Deskt... - Microsoft Fabric Community
Create a hierarchy - Microsoft Support
Create visuals with PowerPoint SmartArt for Power BI - BI Samurai
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i think you can do it by creating hierarchy.
You can create a hierarchy based on the Manager column to represent the organizational structure. To do this:
for Visualizations:
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 |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |