Quick summary
Creating a hierarchy in Power BI lets you group related columns so users can drill down through data levels in reports and visuals. This tutorial walks through the exact steps inside the Power BI Data Model, from opening edit mode to activating the Create Hierarchy option.
Steps
- Go to the top menu bar and click Open Data Model.
- Click the mode selector at the top-right corner of the screen.
- Choose Editing from the list of options to switch into edit mode.
- Navigate to the table containing your data, hover over the column you want to use, and click the More Options button next to it.
- Select Create Hierarchy from the available choices.
- The hierarchy is now created and added to your table automatically.
