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.
Question
Options
- AScatter
- BLine
- CPie
- DRange
How the community answered
(31 responses)- B94% (29)
- C3% (1)
- D3% (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.
Scatter charts display the correlation or distribution between two numeric variables and are not designed to represent trends over a categorical time axis.
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.
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.
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
Community Discussion
No community discussion yet for this question.