Forum Discussion
Helper ICreating hierarchy from a column in organisationtable
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/
Community SupportHi 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/