Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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/
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.
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/
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |