Formatting series colors on a paginated report chart (Report Builder)
Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools
Report Builder provides several built-in palettes for paginated report charts, or you can define a custom palette. By default, charts use the built-in Pacific color palette to fill each series. These colors also appear in the legend. When multiple series are added to the chart, the chart assigns the series a color in the order that the colors have been defined in the palette.
If there are a greater number of series than there are colors in the palette, the chart will begin reusing colors, and two series may have the same color. This frequently occurs if you are using a Shape chart, where each data point is assigned a color from the palette. To avoid confusion, define a custom palette with at least the same number of colors as you have series on your chart.
You can select a new palette or define a custom palette from the Properties pane. For more information, see Define Colors on a Chart Using a Palette (Report Builder and SSRS).
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
Using Built-In Palettes
Reporting Services provides a list of predefined, built-in palettes that you can use to define a color set for series on your chart. All built-in palettes contain between 10 and 16 color values. You cannot extend the built-in palette to include more colors, so if you need more than 16 colors, you must define a custom palette.
If you are printing a report, consider using the Greyscale palette. This palette uses shades of black and white to represent each series in a chart.
The palette named Default was used as the default chart palette in earlier versions of Reporting Services. It has been maintained with the same name for consistency. Charts will upgrade seamlessly using the Default palette, but after upgrading, you might consider changing it.
Using Custom Palettes
If you want to apply your own colors to the chart, use a custom palette. A custom palette let you add your own colors in the order you want them to appear on the chart. A custom palette is especially helpful if the number of series in your chart is unknown at design time. For more information, see Define Colors on a Chart Using a Palette (Report Builder and SSRS).
Using a Color Fill on Each Series
You can also define your own colors on the chart by specifying a color for each series on the chart. To do this, open the Series Properties dialog box and set the Color property for Fill. This approach will override all defined palettes. Generally, it is better to use a custom palette to define your own colors because the number of series in your dataset may not be known until report processing.
This approach is best suited when you want to conditionally set the color of the series based on an expression. For more information, see Formatting Data Points on a Chart (Report Builder and SSRS).
In This Section
Formatting a Chart (Report Builder and SSRS)
Add Bevel, Emboss, and Texture Styles to a Chart (Report Builder and SSRS)
Charts (Report Builder and SSRS)
Formatting the Legend on a Chart (Report Builder and SSRS)