User Hierarchies - Level Properties
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
The following table lists and describes the properties of a level in a user-defined hierarchy.
| Property | Description |
|---|---|
| Description | Contains the description of the level. |
| HideMemberIf | Indicates whether and when a member in a level should be hidden from client applications. This property can have the following values: Never Members are never hidden. This is the default value. OnlyChildWithNoName A member is hidden when the member is the only child of its parent and the member's name is empty. OnlyChildWithParentName A member is hidden when the member is the only child of its parent and the member's name is identical to that of its parent. NoName A member is hidden when the member's name is empty. ParentName A member is hidden when the member's name is identical to that of its parent. |
| ID | Contains the unique identifier (ID) of the level. |
| Name | Contains the friendly name of the level. By default, the name of a level is the same as the name of the source attribute. |
| SourceAttribute | Contains the name of the source attribute on which the level is based. |