To create a hierarchy, select the column in the Fields list that will represent the top level of the hierarchy and use the ellipsis or right-click the menu to select the New hierarchy option, as shown in the following screenshot:
In this example, the Product Category Group column is the top level of the hierarchy and Product Category will be its child or lower level. Likewise, the Product Subcategory column will be a child of Product Category and the Product Name column will be the lowest level of the hierarchy under Product Subcategory. To add columns to the hierarchy, click the ellipsis next to the given column or use the right-click context menu to choose the Add to hierarchy option. Alternatively, the child columns can be dragged and dropped onto the name of the hierarchy by holding down the left mouse button when selecting the column. The levels of the columns can also be adjusted from within the hierarchy by dragging and dropping column names.
Once the hierarchy is created, a single click of the hierarchy name in the fields list adds all the columns and their respective levels to the report visualization. In the following screenshot, all four columns of the Product Hierarchy are added to the Axis of a column chart to support drilling and interactive filter behavior in Power BI:
Certain columns or levels of the hierarchy can optionally be removed from the specific visual. For example, if the report developer only wishes to include Product Category and Product Subcategory in a particular visual, the other two columns can be removed from the Axis field well via the delete (X) icons.