nerdexam
Microsoft

70-466 · Question #161

You are designing a SQL Server Reporting Services (SSRS) report. The report must contain a chart that displays sales data for each product category over time. Sales data must be shown in the form of a

The correct answer is B. Line. A line chart is the correct SSRS chart type for displaying multiple sales trends over time because it supports multiple series rendered as separate lines against a continuous time axis.

Build reports

Question

You are designing a SQL Server Reporting Services (SSRS) report. The report must contain a chart that displays sales data for each product category over time. Sales data must be shown in the form of a line for each product category. You need to add a chart to the report. Which chart type should you use?

Options

  • AScatter
  • BLine
  • CPie
  • DRange

How the community answered

(31 responses)
  • B
    94% (29)
  • C
    3% (1)
  • D
    3% (1)

Why each option

A line chart is the correct SSRS chart type for displaying multiple sales trends over time because it supports multiple series rendered as separate lines against a continuous time axis.

AScatter

Scatter charts display the correlation or distribution between two numeric variables and are not designed to represent trends over a categorical time axis.

BLineCorrect

Line charts in SSRS map a continuous time axis to the x-axis and render each data grouping (product category) as a distinct series line, directly matching the requirement to show one line per category over time. This chart type is purpose-built for visualizing trends and changes across a time dimension with multiple comparable series. The result clearly shows each category's sales trajectory in a single chart view.

CPie

Pie charts show part-to-whole proportions at a single point in time and cannot represent change over multiple time periods or display separate category trend lines.

DRange

Range charts display data between high and low values to show variance or confidence intervals, not discrete per-category trends across a time series.

Concept tested: SSRS line chart selection for multi-series time-series data

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/charts-report-builder-and-ssrs

Topics

#SSRS charts#line chart#data visualization#time series

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice