Org Chart in PBI

[HB2104]

Hello Everyone -

I am looking to create a large organizational chart based on raw data from our HR system. Basically I need columns 1-3 to be able to create a visual of hierarchy. I want to be able to see everyone on one page visual. You can see based on who has a supervisor, how the chart should be built up. Thoughts?

Associate Name	Position Text	Supervisor
Ben Fords	MAINTENANCE MECHANIC	Vonda Charly
Gavlin Than	ELECTRO/MECHANIC	Vonda Charly
Marsha Wang	MAINTENANCE MECHANIC	Vonda Charly
Randa Though	ELECTRO/MECHANIC	Vonda Charly
Vonda Charly	ENAMEL SUPPORT OPERATOR	Amy wanda
Andrew Gland	ENAMEL SUPPORT OPERATOR	Amy wanda
William be	PROCESS CONTROL TECHNICIAN II	Andrew Gland
Hannah Fan	PROCESS CONTROL TECHNICIAN III	Andrew Gland
Sara Land	PROCESS CONTROL TECHNICIAN III	Andrew Gland
Barry June	PROCESS CONTROL TECHNICIAN II	Andrew Gland
Sally Land	PRODUCTION SUPVR-CASTING FINISHING	Hannah Fan
Lip Grand	MANUFACTURING ENGINEER II-MOLDING	Hannah Fan
Angle Form	PROCESS CONTROL TECHNICIAN II	Hannah Fan
Ben Laugh	ENGINEERING TECHNICIAN III	Hannah Fan

[v-saisrao-msft]

Hi @HB2104,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @HB2104,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @HB2104,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @HB2104,

Have you had a chance to look over the solution provided by the @Shahid12523 @Aburar_123 @Ritaf1983 @amitchandak ? If you’re still experiencing the issue, please reply here so we can assist further.

Meanwhile, here’s a link to a solved thread on the same topic that should guide you through the steps:

Solved: How to Create Organization Chart in Power BI Deskt... - Microsoft Fabric Community

Hope this helps

Thank you.

[Shahid12523]

Load your table → use Hierarchy Chart by Akvelon (AppSource).

Set Associate Name = Node

Supervisor = Parent

Position Text = Tooltip/label

This will build the org chart directly. No complex DAX needed unless you want custom levels

[Aburar_123]

Hi @HB2104 ,

You can simply create a matrix visual as below,

Thanks.

[Ritaf1983]

Hi @HB2104 
Check these:
https://www.youtube.com/watch?v=_hyYm8XMmh4

https://www.youtube.com/watch?v=HH6u9u5TZBE

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[amitchandak]

@HB2104 , You have to try some of these custom visuals 

https://appsource.microsoft.com/en-us/marketplace/apps?page=1&search=hierarchy