Microsoft Certified: Power BI Data Analyst AssociateModel the dataEasy
A data modeler is designing a Power BI model for a product catalog. The 'Products' table has columns 'ProductID', 'ProductName', and 'ProductCategory'. The modeler needs to create a hierarchy that allows users to drill down from 'ProductCategory' to 'ProductName'. Where should this hierarchy be defined?
- AIn the Data view by creating new calculated columns.
- BIn the Report view by setting up drill-through pages.
- CIn the Relationships view of the Power BI Desktop.
- DIn the Model view (or Model pane) by dragging columns to create a hierarchy.
Show answer & explanationAnswer & explanation
Correct answer: D. In the Model view (or Model pane) by dragging columns to create a hierarchy.
Hierarchies are defined directly within the Model view in Power BI Desktop by dragging a column onto another column to create a nested structure.
Why the other options are wrong
- A. Calculated columns create new data, but not explicitly a drill-down hierarchy structure.
- B. Drill-through pages allow navigation between reports, but do not define the hierarchical structure itself within a table.
- C. Relationships define how tables connect, not hierarchical drill-down paths within a single table.
Dimension Hierarchies
Dimension hierarchies are predefined paths within a dimension table that enable users to navigate data from general to more specific levels (e.g., Year -> Quarter -> Month).
- Organize related columns into a logical drill-down structure.
- Enhance report interactivity and user experience.
- Defined in the Model view of Power BI Desktop.
- Can be used in visuals like matrices, tables, and bar charts for drill-down/up.
Memory trick: Hierarchies are like a family tree in your model view.