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

Radar Chart in SSRS

by suresh

Radar Chart in SSRS is handy to visualize the numeric data. We can call the SSRS Radar Charts as the Line Charts where X-axis values 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 SSRS or SQL Reporting Services with an example.

For this SSRS radar chart example, we write the Custom SQL query:

-- 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.ProductCategoryKey

and the SQL Data that it’s going to return is:

Radar Chart in SSRS 1

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. The below screenshot will show you the Data Source and Dataset we used for this SSRS Radar Chart Report.

Radar Chart in SSRS 2

In the SSRS report design, we can add a Radar Chart by dragging the Chart property from the Toolbox to Design space. Or right-click on the report designer to open the context menu. From the context menu, please select the Insert -> Chart option.

Radar Chart in SSRS 3

Once you select the Chart option, a new window called Select Chart Type will open to select the required chart from the available once. For this example, we are selecting a Radar Chart.

Radar Chart in SSRS 4

Once you click on the OK button, the Radar Chart will display in the design region with dummy data.

Radar Chart in SSRS 5

Click on the empty space around the SSRS 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). It 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: Specify the Dimension here. It further groups the individual category
Radar Chart in SSRS 6

As we said before, In this example, we will create a 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.

Radar Chart in SSRS 7

Click the Preview button to see the report preview.

Radar Chart in SSRS 8

If you observe the above screenshot, It is providing a 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

The following list of examples will show you the steps involved in formatting the Radar Chart in SSRS

Add Data Labels to Radar Chart

Right-click on the Radar Chart, and select the Show Data Labels option from the context menu to show the values

Radar Chart in SSRS 9

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 it.

Radar Chart in SSRS 10

Here we are changing the font to Baskerville Old Face, font size to 11pt, Color to dark green, and font-weight to Bold

Radar Chart in SSRS 11

Under the Number tab, we changed the default number to Currency with 0 precision.

Radar Chart in SSRS 12

Click the preview to see the report preview

Radar Chart in SSRS 13

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.

Radar Chart in SSRS 14

Here we changed the Font style and font size of the Radial Axis.

Radar Chart in SSRS 15

Change SSRS Radar Chart Title

To change a Radar Chart title, Please select the Chart title region, and change the title as per your requirement. OR, right-click on it will open the context menu. Please select the Title properties.. option.

Radar Chart in SSRS 16

Here we are changing the title as the Radar Chart Example because the report is displaying the same

Radar Chart in SSRS 17

Format 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

Radar Chart in SSRS 18

Click OK to close the properties window, and click on the preview tab to see the report preview

Radar Chart in SSRS 19

Different Radar Charts in SSRS

Let me add the product category to Series group section

Radar Chart in SSRS 20

Click on the SSRS Radar Chart preview tab to see the report preview

Radar Chart in SSRS 21

Here, we just added one more metric (or numeric) column to values section

Radar Chart in SSRS 22

Click on the preview tab to see the report

Radar Chart in SSRS 23

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 it

Radar Chart in SSRS 24

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

Radar Chart in SSRS 25

Click on the preview tab to view the Radar Chart preview

Radar Chart in SSRS 26

From the above screenshot, you can observe that we successfully changed the Chart Type from 2D Radar Chart to 3D Radar chart in SSRS

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