Suggest a chart in PowerBI to create an organizational chart which displays the team wise.

[Rithikas]

 Hello Team.

Given the data in the Excel sheet, Employee ID, Employee Name, Employee Team, Manager ID, and Team ID. Task is to create an org chart that displays like a team and when we click on one of the team members it navigates to that particular team. Here one employee falls under two teams. Team ID: Enterprise Leadership :1 Corporate Development:2

Employee ID Name Job Title Location Manager ID Team Name

1	Robert	Chief Executive Officer	NYC		Enterprise Leadership
2	Emma	Executive Assistant Office Manager	NYC	1	Enterprise Leadership
3	Adam	Group Head of Corp Development & Strategy	NYC	1	Enterprise Leadership, Corporate Development
4	Dee	Group Head of Corp Development & Strategy	NYC	1	Enterprise Leadership
5	Angel	Group Head of Corp Development & Strategy	NYC	1	Enterprise Leadership
6	Wolf	Strategy	NYC	3	Enterprise Leadership
7	John	Head of Corp Development & Strategy	NYC	3	Corporate Development

Thank you

[v-junyant-msft]

Hi @Rithikas ,

After my testing, Power BI Desktop itself does not contain visual objects that would fulfill your requirements, and the form in which your data itself is recorded may also cause problems with visual objects:

It is recommended that you record in multiple columns or rows.

In addition, I found some visual objects in custom visual that may be able to realize your effect, but since custom visual is a third-party-developed visual object for users and other third parties, I can't help you find the relevant documents or provide more detailed technical support, so please try it out yourself, thank you!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rithikas]

Hello @v-junyant-msft . Thank you for working on this.  Are there any visuals other than custom visuals you suggest for the best general Organizational chart of more than 1000 Employees in PowerBI?

[v-junyant-msft · Accepted solution]

Hi @Rithikas ,

Given that you have more than 1,000 Employees, the visual objects that come with Power BI Desktop do not currently have visual objects that clearly show the structure of such a large number of people. So I suggest you can use DAX + Table visual for this. For example:
Here is the dataset:

And here I add a table which contains all of the Names of employees for slicer without any relationship:

Then use this DAX to create a measure:

Measure = 
VAR _Name = SELECTEDVALUE('Slicer'[Name])
VAR _TeamName = MAX('Table'[Team Name])
VAR _CurrentTeam = 
CALCULATE(
    MAX('Table'[Team Name]),
    FILTER(
        ALL('Table'),
        'Table'[Name] = _Name
    )
)
RETURN
IF(
    NOT ISBLANK(_Name) &&
    NOT ISBLANK(_TeamName) &&
    IFERROR(FIND(_TeamName, _CurrentTeam), -1) <> -1,
    1,
    IF(
        IFERROR(FIND(_CurrentTeam, _TeamName), -1) <> -1,
        1,
        0
    )
)

Then please set it according to the following screenshot:

The final output is as below:
If I choose nothing, it will show all of the employees:

If I choose John, it will show employees from team Corporate Development:

If I choose Angel, it will show employees from team Enterprise Leadership:

If I choose Adam, it will show employees both from team Enterprise Leadership and team Corporate Development:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.