How to Create a Hierarchy in Power BI
- George Apostolov
How to Create a Hierarchy in Power BI: step-by-step guide
Go to the top menu bar, then click 'Open Data Model'.
Following that, click the mode selector at the top-right corner.
Choose 'Editing' from the list of options.
Subsequently, head over to the table that contains your data and then hover your mouse cursor over the column you prefer to use. Tap the 'More Options' button next to it.
Pick 'Create Hierarchy' from the given choices.
After completing these steps, the hierarch will be created and added to the table.
Quick answer: To create a hierarchy in Power BI, open the data model from the top menu bar, select Editing from the mode selector, hover over your chosen column in the data table, click More Options, and pick Create Hierarchy.
About this Power BI tutorial
Easily organize your data in Power BI by building a custom hierarchy directly from your table columns using the editing mode options. This guide shows how to create a Hierarchy in Power BI in 6 steps, starting with "Go to the top menu bar, then click 'Open Data Model'" and finishing with "After completing these steps, the hierarch will be created and added to the table". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create a Hierarchy in Power BI?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Create a Line Chart in Power BI, How to Create a Map in Power BI and How to Create a Measure in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
