Hidden hierarchies
Choosing which attributes belong in a hierarchy can help users make sense of reports and include the ability to drill down in a natural fashion. As a result, it can make sense to group several dimensions into one natural hierarchy in your data model.
In this exercise, you want to clean up your data model by creating two natural hierarchies for Date
and Product
.
This exercise is part of the course
Intermediate Data Modeling in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
