Define colors on a paginated report chart using a palette (Report Builder)

Applies to: ✅ Microsoft Report Builder (SSRS) ✅ Power BI Report Builder ✅ Report Designer in SQL Server Data Tools

You can change the color palette for a paginated report chart by selecting a pre-defined palette or defining a custom palette. Custom palettes are chart-specific.

Note

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.

To change the colors on the chart using a built-in color palette

  1. Open the Properties pane.

  2. On the design surface, click the chart. The properties for the chart object are displayed in the Properties pane.

    The object name (Chart1 by default) appears in the drop-down list at the top of the Properties pane.

  3. In the Chart section, for the Palette property, select a new palette from the drop-down list.

    Note

    You cannot change the colors or order in a pre-defined palette.

To define your own colors on the chart using a custom color palette

  1. Open the Properties pane.

  2. On the design surface, click the chart. The properties for the chart object are displayed in the Properties pane.

  3. In the Chart section, for the Palette property, select Custom.

  4. In the CustomPaletteColors property, click the Edit Collection (...) button. The ReportColorExpression Collection Editor opens.

  5. Click Add to add a color. Select a color from the drop-down list or select Expression and specify a hex value for a specific color, such as ff6600 for "Orange".

    For more information about hex values, see Color Table on MSDN.

  6. Click Add to add more colors to the palette.

  7. When you are done, click OK.

If you are using a custom palette, you can change the order of the colors to change the color of different series in the chart.

See Also

Formatting Series Colors on a Chart (Report Builder and SSRS)
Charts (Report Builder and SSRS)
Specify Consistent Colors across Multiple Shape Charts (Report Builder and SSRS)