You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson. The cube contains a Key Pe

A Sparkline renders a compact trend chart over a series of data points and is not designed to display a single discrete KPI status icon.

A Radial Gauge displays a numeric value on a circular dial within a range; it does not render flag-style KPI status icons and is not suited for discrete three-state color coding.

An Indicator is an SSRS report item that maps a numeric KPI status value to a small icon from a predefined set such as flags, arrows, or shapes, each with configurable colors. The Flags indicator set natively supports three states - typically red, yellow, and green - corresponding to off target, slightly off target, and on target KPI values sourced directly from an SSAS cube KPI field. No custom expressions are needed because the indicator states align directly with standard KPI status values (-1, 0, 1).

A Linear Gauge displays a value along a linear scale and shares the same limitation as a Radial Gauge - it shows numeric position, not a discrete colored status icon.

A Data Bar is a miniature bar chart used to compare relative values across rows in a table or matrix and does not represent a single KPI status with colored flag icons.