SSRS 3-D Clustered Column Chart

This SSRS article shows how to create a 3-D Clustered Column Chart, Show Data Labels, and format fonts and colors with an example. To demonstrate this example, right-click on the Datasets folder to create a new DataSet. 

The below screenshot shows the data set that we use for this example.

• Shared Data Source.
• Embedded Data Source.
• Embedded DataSet.

The Sql query that we used above SSRS example is:

SELECT Geo.[EnglishCountryRegionName] AS [Country]
	,Cust.EnglishOccupation AS Occupation
	,SUM(Fact.SalesAmount) AS Sales
FROM  DimCustomer AS Cust
INNER JOIN FactInternetSales AS Fact ON Cust.CustomerKey = Fact.CustomerKey
INNER JOIN [DimGeography] AS Geo ON Cust.GeographyKey = Geo.GeographyKey
GROUP BY Geo.[EnglishCountryRegionName],Cust.EnglishOccupation

SSRS 3-D Clustered Column Chart

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

Select the 3-D Clustered Column Chart from the window and click OK to add to the report area.

Use Plus button or drag the fields to the Values and Category Groups section.

Here, we added the Sales column to Values, the Country column to Category Groups, and Occupation Field to Series Groups. Next, right-click on the 3D clustered Columns and select the Show Data Labels option to add labels.

Right-click the Data Labels and select the Series Label Properties option to format Number as Currency and show values in Thousands.

Click the preview button to see the 3D Clustered Columns chart.

Select the complete chart and change the palette to Earth Tone.

Preview the report.