# How to Create a Hierarchy in Power BI

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-create-a-hierarchy-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a370fab56e05a00fdc475/preview?step=1

## Steps

1. Go to the top menu bar, then click 'Open Data Model'.
2. Following that, click the mode selector at the top-right corner.
3. Choose 'Editing' from the list of options.
4. 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.
5. Pick 'Create Hierarchy' from the given choices.
6. After completing these steps, the hierarch will be created and added to the table.