Power BI Data Analyst (PL-300) · Free practice question 9 of 12
Constant line for target
A clustered column chart shows daily calls handled per agent. The contact centre manager wants a horizontal line at the service target of 120 calls so agents below target stand out. What is the simplest way to add it?
- A.Create a calculated column that stores 120 for every row
- B.Add 120 as a text box on top of the chart
- C.Add a Y-axis constant line with a value of 120 in the Analytics pane
- D.Add a forecast in the Analytics pane
Show answer and explanation
Correct answer: C. Add a Y-axis constant line with a value of 120 in the Analytics pane
Why: A constant line in the Analytics pane draws a reference line at a fixed value, or at a value from a measure, across the chart and can be labelled. A calculated column adds data to the model without drawing a line. A forecast predicts future values, and a text box is not tied to the axis scale.