Forum Discussion
Category
I have a dataset which has employees categorized by level but does not have a hierachy. I am trying to create a visual where all employees are categorized and then sorted by level but I am unable to ...
Hello,
I think my question was incorrect. I need to create a diagram where each level is sorted from lowest to highest and each name and skill level is displayed completely. it can be a pyramid where CEO is at the top, all partners below and so on.
Here is my sample data:
| RecordID | Employee Name (Last Suffix, First MI) | Department | Skill Level | Office | Level |
| 1 | Name 1 | Audit | Ceo | Downtown | 0 |
| 2 | Name 2 | Audit | Partner | Downtown | 1 |
| 3 | Name 3 | Audit | Partner | Downtown | 1 |
| 4 | Name 4 | Audit | Senior Manager | Downtown | 2 |
| 5 | Name 5 | Audit | Manager | Downtown | 3 |
| 6 | Name 6 | Audit | Manager | Downtown | 3 |
| 7 | Name 7 | Audit | Manager | Downtown | 3 |
| 8 | Name 8 | Audit | Senior | Downtown | 4 |
| 9 | Name 9 | Audit | Senior | Downtown | 4 |
| 10 | Name 10 | Audit | Senior | Downtown | 4 |
| 11 | Name 11 | Audit | Senior | Downtown | 4 |
| 12 | Name 12 | Audit | Staff | Downtown | 5 |
| 13 | Name 13 | Audit | Staff | Downtown | 5 |
| 14 | Name 14 | Audit | Staff | Downtown | 5 |
| 15 | Name 15 | Audit | Staff | Downtown | 5 |
| 16 | Name 16 | Audit | Staff | Downtown | 5 |
| 17 | Name 17 | Audit | Staff | Downtown | 5 |
HI farriyajawed,
Perhaps you can try to add field to mapping the record and the parent level to transform the table to parent child hierarchy structures.
Parent-child hierarchies – DAX Patterns
Regards,Xiaoxin Sheng