PL-300 Analytics pane Practice Question
You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?
⚠ Common exam trap
A common trap is confusing the Forecast option with the Trend line option. Both are in the Analytics pane, but they serve different purposes: Forecast predicts future values, while Trend line shows the general direction of existing data.
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
✓
Analytics pane in the visual
The Analytics pane in the visual (option D) is the correct feature because Power BI provides built-in trend line support there; selecting the visual, opening the Analytics pane, and adding a Trend line overlays a linear regression line on the line chart to show the overall direction of sales over time. The Forecast option (option A) is also in the Analytics pane but is designed to project future values using exponential smoothing, not to display a historical trend line. Writing a DAX measure for linear regression (option B) is unnecessary and more complex since Power BI already offers a native trend line, and the Format pane (option C) only changes cosmetic line styling such as color, width, or dash type, not the trend calculation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Forecast option in the visual
Why it's wrong here
Forecasting projects future data points beyond the existing series using time-series algorithms; it does not draw a trend line through historical values. It is tempting because both appear on the Analytics pane, but forecasting answers what comes next, whereas a trend line summarises direction across existing months.
- ✗
Add a DAX measure for linear regression
Why it's wrong here
While a DAX measure could calculate a linear regression line, it would require writing custom DAX to compute slope and intercept, then plotting that as a separate series on the chart. This fails the scenario because Power BI’s built-in Analytics pane offers a one-click trend line that automatically fits to the existing series without manual measure creation. The temptation arises because DAX can perform statistical calculations, and in scenarios requiring custom regression parameters or multiple trend lines from different measures, a DAX approach would be the correct choice.
- ✗
Format pane to change line style
Why it's wrong here
Changing line style alters only the visual appearance of the plotted series; it adds no computed trend line. It is tempting because the Format pane does control the chart's lines, but the Analytics pane's Trend Line toggle is what inserts the regression line over the series.
- ✓
Analytics pane in the visual
Why this is correct
The Analytics pane adds trend lines, forecasting, and other statistical overlays to an existing visual. For a line chart of monthly sales, it inserts the trend line directly, showing overall direction without altering the underlying data model.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.