Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Formatting Data Bars in SSRS

by suresh

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

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy