PL-300 Visualize and analyze the data Practice Question
A company has a dataset with a table 'Orders' containing columns: OrderDate, CustomerID, Amount. They want to create a visual that shows the total amount per month. Which of the following is the best approach?
⚠ Common exam trap
Watch out — candidates often think extracting a month column manually (Option D) is the most straightforward approach, but the exam tests whether you understand that Power BI's built-in date hierarchy is the optimal and intended method for time-based aggregations, avoiding unnecessary calculated columns.
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 line chart with OrderDate on the axis and use the date hierarchy to drill down to month.
It leverages Power BI's built-in date hierarchy, which automatically groups OrderDate by year, quarter, month, and day. By placing OrderDate on the axis of a line chart and drilling down to the month level, you get an accurate monthly aggregation of Amount without needing any manual data transformation or calculated columns. This approach is efficient, maintains the underlying data model's integrity, and allows for easy drill-up/drill-down navigation.
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 a pie chart with OrderDate as the legend.
Why it's wrong here
A pie chart partitions data into slices for part-to-whole comparison, but placing OrderDate as the legend creates a slice per distinct date value. This produces an unreadable visual with dozens or hundreds of slices, obscures the chronological trend, and fails to show how Amount changes over time. Pie charts lack a continuous axis for temporal data, making them unsuitable for time-series analysis.
- ✓
Create a line chart with OrderDate on the axis and use the date hierarchy to drill down to month.
Why this is correct
Using a line chart with OrderDate on the axis and the built-in date hierarchy enables drill-down from year to quarter to month without extra measures or columns. This hierarchy is auto-generated by Power BI for date columns, supports correct chronological sorting, and provides a natural, interactive way for users to explore trends at multiple granularities. The line chart's continuous axis is ideal for showing changes in Amount over time.
- ✗
Create a table visual with OrderDate and Amount, then group by month in the visual.
Why it's wrong here
A table visual is designed for detailed data inspection and exact values, not for trend detection. Grouping by month inside a table is possible but requires manual aggregation or the Query Editor, and it does not offer the visual continuity needed to see patterns over time. Unlike a date hierarchy, a table grouping has no built-in drill-down or interactive level navigation, making it inefficient for time-series analysis.
- ✗
Create a bar chart with a calculated column 'Month' extracted from OrderDate and use that as the axis.
Why it's wrong here
Creating a calculated Month column with DAX and using it as a bar chart axis is technically feasible, but it bypasses Power BI's native date hierarchy. This approach is static because the column is fixed at a single granularity, requiring additional calculated columns for year or quarter if other levels are needed. It also often causes alphabetical month sorting (April before January) unless extra sorting logic is added, making it less flexible and more error-prone than using a date hierarchy.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-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 →
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.