Creating hierarchy from a column in organisationtable

[soderqvistn]

How would I create a hierarchy in my organisationtable

I want to grade my organisation type column as this: Company -> Region -> Dsitrikt -> Project in order to be able to use drilldown function smoothly.

[v-diye-msft]

Hi @soderqvistn 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

If the problem still exists, please kindly share your dummy pbix/simple worksheet, I'll draw it up for you.

[v-diye-msft · Accepted solution]

Hi @soderqvistn 

Method 1. In order to create a new hierarchy in Power BI, Drag and drop one field on to the other. This will automatically create a Hierarchy for you. To demonstrate the same, we are dragging the product subcategory onto the product category field.

Now you can see the newly created hierarchy.

Method 2. Please select the field that you want to add (let me select product), and right-click on it will open the context menu. Select the Add to Hierarchy, and then select the Hierarchy name (Product Category Hierarchy)

More details please refer to this post:

https://www.tutorialgateway.org/create-hierarchy-in-power-bi/