SSRS Bar Chart

This SSRS article shows how to create a Bar Chart, Show Data Labels, change default bar colors, and format its font and colors with an example. To demonstrate this example, right-click on the Datasets folder to create a new DataSet. Writing the below code inside the SSMS shows the data set that we use for this example.

The Sql query that we used in this SSRS example is:

SELECT Geo.EnglishCountryRegionName AS Country, 
SUM(Fact.TotalProductCost) AS TotalCost, SUM(Fact.SalesAmount) AS Sales
FROM FactInternetSales AS Fact INNER JOIN DimCustomer
ON DimCustomer.CustomerKey = Fact.CustomerKey JOIN DimGeography AS Geo
ON DimCustomer.GeographyKey = Geo.GeographyKey
GROUP BY Geo.EnglishCountryRegionName

SSRS Bar Chart

To add a Bar Graph, right-click the report area, choose Insert, and then the chart option from the context menu. Otherwise, drag and drop the chart from the toolbox to the report area.

Choose Insert Chart Option

Select the Bar chart from the window and click OK to add to the report area.

Select SSRS Bar Chart

Use the Plus button or drag the fields to the Values and Category Groups section. Here, we added the Sales column to the Values and Country column to the Category Groups section. 

Add Columns to Values and Category Groups

Click the Preview tab to see the SSRS Bar Chart report.

Preview SSRS Bar Chart

Here, we used the toolbar to format the bar chart font and color of the X-axis, Y-axis, data labels, and legend. However, you can use the properties window to format the report. Next, right-click on the bars and select the Show Data Labels option to add labels.

Show Data Labels in SSRS Bar Chart

Right-click the Data Labels and select the Series Label Properties option to format bar chart Numbers as Currency.

Format Data Labels Numbers

To change the default bar color, right-click and select Series properties. Next, go to the Fill tab, pick Fill styles Solid, and choose the color per your requirement.

Change Default rectangle colors

Click the preview button to see the SSRS Bar chart.

SSRS Bar Chart With Custom Color Preview

To compare multiple measure values horizontally, let me add the Product Cost column to the Values section and enable Data Labels for the Product cost. 

Add Two Fields to Values section

Preview the SSRS Bar Chart report to compare two measures.

Preview of SSRS Bar Chart comparing two Measures