Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayUser-Defined Hierarchies - Create
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
SQL Server SQL Server Analysis Services lets you create user-defined hierarchies. A hierarchy is a collection of levels based on attributes. For example, a time hierarchy might contain the Year, Quarter, Month, Week, and Day levels. In some hierarchies, each member attribute uniquely implies the member attribute above it. This is sometimes referred to as a natural hierarchy. A hierarchy can be used by end users to browse cube data. Define hierarchies by using the Hierarchies pane of Dimension Designer in SQL Server Data Tools.
When you create a user-defined hierarchy, the hierarchy might become ragged. A ragged hierarchy is where the logical parent member of at least one member is not in the level immediately above the member. If you have a ragged hierarchy, there are settings that control whether the missing members are visible and how to display the missing members. For more information, see Ragged Hierarchies.
User Hierarchy Properties
Level Properties - user hierarchies
Parent-Child Dimensions
Additional resources
Training
Module
Use hierarchies and DAX in your first data model - Online workshop - Training
In this module, you add measures to a Power BI data model for the first time. You use hierarchies, matrix visuals, and DAX in your data model to explore the data further.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.