Org chart without 'parent id', only a field 'manager'

Hi shettysunith 

In Power Query you could create a Parent id and child id to enable you to use one of the org chart visuals. The steps would be:

1. Open Power Query.
2. With the Org Data table selected, go to Add Column > Index Column > From 1.
3. Rename the index column "Child Id" (you can name it whatever you want but let's go with Child id for simplicity)
4. In the Org Data table, right click on the Manager field and select Add as New Query.
5. From the Transform menu select "Remove Duplicates" and then Convert "To Table". Rename the table "Managers".
6. In the new table (containing manager names) go to Add Column > Index Column > From 1.
7. Rename this new index column as "Parent Id"
8. Select the Org Data table. Select Merge queries, and merge the Org Data and the Managers table via the manager name. The join kind can be Left Outer.
9. Click on the outward facing arrow icon in the top-right of the new column (containing the word "Table" repeatedly)
10. Expand only the Parent Id column.
11. Close & Apply power query.
12. You can now create a relationship between the Managers table and the Org Data table via the "Parent Id" column. 

Will this now allow you to create an org chart?