You probably know this already but a hierarchy is a system where elements or entities are ranked over the other.
In Power BI, hierarchy is commonly seen in date and time data.
Here’s an example of a Power BI hierarchy:
Hierarchies in Power BI can be spotted easily because of the hierarchy icon.
Also, hierarchies aren’t only limited to dates.
For example, you could put a hierarchy on production information:
- Product Category
- Product Subcategory
So why are hierarchies important in Power BI?
Simple. Data hierarchy allows you to drill up or down on your visual and reveal additional details.
Take a look at hierarchy and drill through in action: