Formatting Data Bars in SSRS

In this article, we will show you the steps involved in the Formatting Data Bars in SSRS. It includes how to change the Data Bar Colors, Data Bar type, add Custom colours, and converting the Data bar to full chart in SSRS with an example.

Formatting Data Bars in SSRS

To explain the available Format options, We are going to use the below-shown Report. Please refer to the SSRS Data Bars article to understand the Data Source and Dataset we used for this SSRS Report.

Formatting Data Bars in SSRS 1

Formatting Data Bar Color in SSRS

We usually change the data bar color using some conditions. For instance, if the sales amount is less than the threshold point, then Red color or something like that.

To Format the SSRS data bar color, Right-click on the Blue bars and select the Series properties… option from the context menu.

Formatting Data Bars in SSRS 2

Once you click on the Series properties… option, a new window will open with many properties. Here, we can change the visibility, Border colors, Shadow effects, and Actions as well.

In this example, we will change the color of the data bars using the condition so, Goto Fill tab and click on the fx button

TIP: If you want to change the color without any condition, then select the color from the drop-down list.

Formatting Data Bars in SSRS 3

Once you click on the fx button, a new Expression window will be opened to write the custom expression for the color. We are going to use the below expression.

Expression:

=IIF(
      Sum(Fields!SalesAmount.Value) > 1000000, "Green",
           IIF(Sum(Fields!SalesAmount.Value) > 100000, "Blue","Red")
     )

Analysis:

  • If the Sum of Sales Amount is greater than 1000000, then Data Bar will be filled with Green color
  • If the Sum of Sales Amount is greater than 100000, then Data Bar will be filled with Blue color
  • Otherwise Red color
Formatting Data Bars in SSRS 4

Click Ok to finish assigning colors. Click the preview button and see the Report preview

Formatting Data Bars in SSRS 5

From the above screenshot, you can observe that the Report is generating three different colors based on the given expression.

Format Horizontal & Vertical Axis Properties of SSRS Data Bars

Right-click on the Blue bars will open the context menu. From the menu, please select Horizontal Axis Properties option as we have shown in below screenshot

Formatting Data Bars in SSRS 6

Once you choose the Horizontal Axis Properties option, a new window called Horizontal Axis Properties to configure the range and Scale options as per company requirements.

Formatting Data Bars in SSRS 7

If you want to format the vertical Axis properties, select the Vertical Axis Properties option. Once you selected a new window called Vertical Axis Properties to configure the range, margins, and Scale options as per company requirements.

Formatting Data Bars in SSRS 8

Change SSRS Data Bar Type

SSRS allows us to change the Data bar type even after creating the Data Bar. First, select the Data Bar, and right-click on it will open the context menu. Please select the Change Data Bar Type… option from the context menu

Formatting Data Bars in SSRS 9

Once you select the Change Data Bar Type… option, it will open a new window to select the new Data Bar or data Column. Here we are selecting simple Data Column

Formatting Data Bars in SSRS 10

Click Ok to finish and preview the report

Formatting Data Bars in SSRS 11

Converting Data Bar to Full Chart in SSRS

SSRS allows us to convert the Data Bar to Chart. First, select the Data Bar, and right-click on it will open the context menu. Please choose the Convert to Full Chart option

Formatting Data Bars in SSRS 12

Once you select the Convert to Full Chart option, Data Bar will be replaced by the Column Chart with Vertical and Horizontal Axis as shown in below screenshot

Formatting Data Bars in SSRS 13

Here, We removed the Axis Titles, Chart Title, Legend Title, and formatted the Numeric values as well.

Formatting Data Bars in SSRS 14

Let us click on the preview to preview the Data bar report

Formatting Data Bars in SSRS 15