Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
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.
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.
User | Count |
---|---|
117 | |
74 | |
62 | |
50 | |
45 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |