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 do so. Can someone help please.
4 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523if the level categorisation is a numerical column you can sort the displayed column in your visual by this numerical hierarchy.
Dummy data using fruit with order preference:
Sort the Fruit column by Preference by left clicking the Fruit column, and then clicking "sort by column" and selecting what you want.
This will sort your desired column by the number field (e.g. categorisation) creating a hierarchy based on the number:
if the categorisation column is not numerical - you may need to create a helper table by clicking Enter Data and creating a supporting table that can be conncted via a relationship, and then you can sort by doing this method.
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
