Radar Chart in SSRS is very useful to visualize the numeric data. We can call the Radar Charts as the Line Charts where X-axis values are wrapped in 360 degrees.
In this article, we will show you, How to create a Radar Chart in SSRS, How to change its Title, Radar Chart Font style, Chart Model, and Display Data Labels on Radar Chart in SQL Reporting Services with an example.
For this example, we are going to write the Custom SQL Query against the SQL Server Data Source, and the query that we are going to use for this report is:
-- SQL Query that we use in SSRS Radar Chart
SELECT Cat.[EnglishProductCategoryName] AS ProductCategory,
SubCat.[EnglishProductSubcategoryName] AS ProductSubCategory,
Prod.EnglishProductName AS ProductName,
Prod.Color,
Fact.OrderQuantity,
Fact.TotalProductCost,
Fact.SalesAmount,
Fact.TaxAmt,
Fact.[Freight]
FROM FactInternetSales AS Fact
INNER JOIN DimProduct AS Prod
ON Fact.ProductKey = Prod.ProductKey
INNER JOIN DimProductSubcategory AS SubCat
ON Prod.ProductSubcategoryKey = SubCat.ProductSubcategoryKey
INNER JOIN DimProductCategory AS Cat
ON SubCat.ProductCategoryKey = Cat.ProductCategoryKeyand the Data that it’s going to return is:
Create a Radar Chart in SSRS
In this example, we are going to create a Radar Chart to display the Sales Amount grouped by product Color in 30 degrees. Below screenshot will show you the Data Source and Dataset we used for this Radar Chart Report.
In SSRS report design, we can add a Radar Chart by dragging the Chart property from the SSRS Toolbox to Design space. Or we can simply right-click on the report designer to open the context menu. From the context menu, please select the Insert -> Chart option as we shown below.
Once you select the Chart option, a new window called Select Chart Type will be opened to selectthe required chart from the available once. For this example, we are selecting Radar Chart as shown in below screenshot.
Once you click on Ok button, Radar Chart will be displayed in the design region with dummy data.
Click on the empty space around the Radar Chart will open the Chart Data window
- Values: Any Numeric (Metric) value such as Total Sales, Sale amount, Number of Customers, Tax etc. All these values will be aggregated using an aggregate function (Sum, Avg, Count etc). This is because we are grouping them with the category group items.
- Category Group: Please specify the Column name that you want to use to divide the axis.
- Series Group: Please specify the Dimension here. This will further group the individual category
As we said before, In this example we will create Radar Chart to find the sales amount by color so, Drag and drop the sales amount column from data set to chart data values, Product Color to category group.
NOTE: Please be careful when dragging the columns to values region, if you mishandled or dropped in design area will end up in mess.
Click on the Preview tab to see the report preview.
If you observe the above screenshot, It is providing perfect result but we are unable to identify the exact sales amount of each color. So, let us add the Data Labels.
Format Radar Chart in SSRS
Following list of examples will show you the steps involved in formatting the Radar Chart in SSRS
Add Data Labels to Radar Chart in SSRS
Right click on the Radar Chart, and select the Show Data Labels option from the context menu to show the values
Next, let me format the Font of Data Labels. To do so, Please select the Data labels, and right click on it will open the context menu. Here, please select the Series Label Properties option from the context menu as we shown below.
Here we are changing the font to Baskerville Old Face, font size to 11pt, Color to dark green, and font weight to Bold
Under the Number tab, we changed the default number to Currency with 0 precision.
Click on the preview tab to see the report preview
Change Axis properties of a Radar Bar Chart in SSRS
Right click on the Axis of a Radar Bar Chart, and select the Radial Axis Properties.. option from the context menu to format the Axis values.
Here we changed the Font style, and font size of the Radial Axis.
Change SSRS Radar Chart Title
To change a Radar Chart title, Please select the Chart title region as we shown in below screenshot, and change the title as per your requirement. OR, right-click on it will open the context menu. Please select the Title properties.. option from the context menu as shown below.
Here we are changing the title as Radar Chart Example because the report is displaying the same
Format SSRS Radar Chart Title Font
Within the Font tab, we can change the Font Size, Font Family, Font Style and Color of a Radar Chart Title. Here we are changing the Font to Baskerville Old Face, Font size to 14pt, and color to Indigo, and style to Bold as shown in below screenshot
Click OK to close the properties window, and click on the preview tab to see the report preview
Different Radar Charts in SSRS
Let me add the product category to Series group section
Click on the preview tab to see the report preview
Here, we just added one more metric (or numeric) column to values section
Click on the preview tab to see the report preview
SSRS allows us to change the chart type even after creating a Radar Chart. To do so First, select the Radar Chart and right-click on it will open the context menu. Please select the Change Chart Type… option from the context menu
Once you select the Change Chart Type… option, it will open a new window called Select Chart Type to select the change. Here we are selecting the 3-D Radar Chart
Click on the preview tab to see the report preview
From the above screenshot, you can observe that, We successfully changed the Chart Type from 2D Radar Chart to 3D
Thank You for Visiting Our Blog