Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise