SSRS 3D Cylinder Chart

This SSRS article shows how to create a 3D Cylinder Chart to compare two measures against a dimension, 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 SSRS 3D Cylinder Chart example.


The Sql query that we used above SSRS example is:

SELECT Geo.[EnglishCountryRegionName] AS [Country]
	,SUM(Fact.SalesAmount) AS Sales
	,SUM(Fact.TotalProductCost) AS ProductCost
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]

SSRS 3D Cylinder Chart

To add a 3D Cylinder, 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.

Insert a Chart

Select the 3D Cylinder chart from the window and click OK to add to the report area.

Choose SSRS 3D Cylinder Chart

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

Add Columns to Values and Category Groups

Here, we added the Sales column to the Values and Country column to the Category Groups section. Next, right-click on the 3d cylinder and select the Show Data Labels option to add labels.

Show Data Labels in SSRS 3D Cylinder Chart

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

Format. Data Label Numbers

Let me select the chart and change the palette to Earth Tones.

Change the Palette

Click the preview button to see the SSRS 3D Cylinder chart.

SSRS 3D Cylinder Chart Preview

To compare multiple measure values, let me add the Product Cost column to the Values section and enable Data Labels. Here, we used the toolbar to format the 3d cylinder font, color, and size of the X-axis, Y-axis, data labels, and legend. However, you can use the properties window to format the report.

Add Another Product Cost Measure to Values Section

Preview the report.

SSRS 3D Cylinder Chart with Multiple Measures Preview

Let me remove the Product cost column from the Values section, right-click on the 3d cylinder and select Series properties. Next, go to the Fill tab, select Fill styles Solid, and click the ƒx button to write the expression.

The below switch statement assigns different colors for each country.

=Switch(Fields!Country.Value = "Australia", "Yellow",
	Fields!Country.Value = "Canada", "Blue",
	Fields!Country.Value = "France", "DarkViolet",
	Fields!Country.Value = "Germany", "Maroon",
	Fields!Country.Value = "United States", "Green",
	Fields!Country.Value = "United Kindgom", "Magenta")
Custom Colors Expression

Let me show you the SSRS 3D Cylinder Chart preview.

Preview of SSRS 3D Cylinder Chart with Custom Colors