Courseiva
← PL-300
Full test
Model the data →easyMultiple Choice

PL-300 Model the data Practice Question

You need to create a hierarchy in Power BI that allows drilling down from Year to Quarter to Month. What is the correct approach?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Create a hierarchy in the Date table using Year, Quarter, Month columns

The correct option is D: create a hierarchy in the Date table using the Year, Quarter, and Month columns. In Power BI, a hierarchy is built by dragging fields onto each other in the Fields pane, so placing Year above Quarter above Month in a date table produces exactly the Year → Quarter → Month drill-down path required. The other options do not fit: A (separate measures) produces independent calculations, not a drillable hierarchy; B (Drillthrough) navigates to a separate report page filtered by a selected value, not down levels within a visual; and C (DATESYTD) is a time-intelligence function that returns year-to-date totals, not a hierarchy.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Create separate measures for each level

    Why it's wrong here

    Separate measures for each level calculates aggregates at different granularities, but measures only produce numeric values; they do not define a navigable level structure. Without a defined hierarchy, a visual cannot know which field to drill into next, so the drill-up/drill-down icons won't appear.

  • ✗

    Use the Drillthrough feature

    Why it's wrong here

    The Drillthrough feature opens a separate report page when a user clicks a data point, applying filters to that target page's visuals. It does not expand the original visual's axis or values in place, so it lacks the hierarchical drill-down behavior that a date hierarchy provides.

  • ✗

    Use the DATESYTD function

    Why it's wrong here

    DATESYTD is a DAX time-intelligence function that calculates year-to-date totals by modifying filter context over a date column. It has no effect on visual level navigation or on the modeled relationships between Year, Quarter, and Month, so it cannot make drillable levels available.

  • ✓

    Create a hierarchy in the Date table using Year, Quarter, Month columns

    Why this is correct

    Creating a hierarchy in the Date table by placing Year above Quarter above Month defines a parent-child level structure that visuals can traverse. When a report field includes this hierarchy, Power BI automatically adds drill-down and expand controls, letting you move from annual to quarterly to monthly detail in the same chart.

About these practice questions

This PL-300 question is part of Courseiva's 524-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more way this is tested on PL-300

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. You need to create a hierarchy in Power BI that allows users to drill down from Year to Quarter to Month. Which of the following actions is required?

easy
  • A.Create a relationship between the Year, Quarter, and Month columns.
  • B.Create the hierarchy in the report view by grouping fields.
  • ✓ C.In the Fields pane, right-click a column and select 'Create hierarchy', then add child columns.
  • D.Use Power Query to merge the columns into one.

Why C: A hierarchy is created by selecting multiple columns in the same table and defining a parent-child relationship. Option A is incorrect because relationships are between tables, not within a hierarchy. Option B is incorrect because hierarchies can be created in the model view, not only in report view. Option D is incorrect because you cannot create a hierarchy in Power Query.

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.