Creating Hierarchies and Groups

Hierarchies and groups are semantic model structures that can be implemented to simplify the user and report authoring experience. Hierarchies provide single-click access to multiple columns of a table, enabling users to navigate through pre-defined levels, such as the weeks within a given month. Groups comprise individual values of a column that enable analysis and visualization of the combined total as though it is a single value. Hierarchies and groups have useful applications in almost all semantic models, and it is important to understand the relationship of these structures to the semantic model and visualizations.

This recipe provides an example of utilizing DAX parent/child hierarchy functions to create columns of a hierarchy. The hierarchy is then implemented into the semantic model, and a group is created to further benefit the analysis.

Getting ready

To prepare for this recipe, follow these steps:

1. Open Power BI Desktop...