Search results
Suggest a FeaturePDF

Polar Chart

The Polar Chart visualizes data in terms of values and angles. It provides options for visual comparison between several quantitative or qualitative aspects of a situation.

Add chart to the report

These types of charts are categorized under the Distribution category in the item panel.

Drag and drop the polar chart from the item panel into the design area.

Chart Types

Now, the polar chart will be rendered in the design area and the chart properties will be listed in the properties panel.

Chart Types

Create data

To present data in the chart, create a dataset and bind data to the chart data region. In this designing section, the following json data is used for dataset creation.

[
    {
        points: [
            { Month: 'Jan', Celcius: -7.1 }, { Month: 'Feb', Celcius: -3.7 },
            { Month: 'Mar', Celcius: 0.8 }, { Month: 'Apr', Celcius: 6.3 },
            { Month: 'May', Celcius: 13.3 }, { Month: 'Jun', Celcius: 18.0 },
            { Month: 'Jul', Celcius: 19.8 }, { Month: 'Aug', Celcius: 18.1 },
            { Month: 'Sep', Celcius: 13.1 }, { Month: 'Oct', Celcius: 4.1 },
            { Month: 'Nov', Celcius: -3.8 }, { Month: 'Dec', Celcius: -6.8 }],
         Country: 'Warmest'
    },
    {
        points: [
            { Month: 'Jan', Celcius: -17.4 }, { Month: 'Feb', Celcius: -15.6 },
            { Month: 'Mar', Celcius: -12.3 }, { Month: 'Apr', Celcius: -5.3 },
            { Month: 'May', Celcius: 1.0 }, { Month: 'Jun', Celcius: 6.9 },
            { Month: 'Jul', Celcius: 9.4 }, { Month: 'Aug', Celcius: 7.6 },
            { Month: 'Sep', Celcius: 2.6 }, { Month: 'Oct', Celcius: -4.9 },
            { Month: 'Nov', Celcius: -13.4 }, { Month: 'Dec', Celcius: -16.4 }],
        Country: 'Coldest'
    }
]

Refer to the Create Data section for more information. Here, we are going to create a dataset using JSON inline data to design the report.

Assign data

The Polar Chart needs a minimum of one value element and one column element to showcase. The measure or expression field that you want to analyze can be dropped into the Y Value(s) section. The dimension for which you want to categorize the measure can be dropped into the Column section. To categorize the measure based on a series, drop the respective dimension into the Row(s) section.

To configure data into a polar chart, follow the steps:

  1. To bind data to a chart report item placed in the design area, focus on that report item.

  2. Click the Properties icon in the configuration panel, the property pane opens. Now, switch to the DATA tab.

    Chart properties pane

  3. The available data in the report will be listed in the dropdown, choose a data in the dropdown list.

    Choose the dataset for chart

  4. The numeric columns and numeric expressions are listed under the Measures section; other types of columns and dimension expressions are listed under the Dimensions section.

    Measures and dimensions

  5. Drag and Drop Measure Element:

    Select and drag the numeric column (measure element) or the numeric expression column from the Measure section and drop it in the Y Value(s) section.

    Add a Y-value field

    Now, the report item design will look like below:

    Preview after adding y-value field

  6. Aggregate Options:

    Click the Settings icon (highlighted below) to open the aggregation type dropdown list.

    Aggregate settings icon

    You can set the aggregation type by which you can compute the selected column.

    Aggregate menu list

  7. Drag and Drop Dimension Element:

    Select and drag the dimension element from the Dimensions section to measure against any of the selected numeric column(s) in Y Value(s) section, and drop it into the Column section.

    Add dimension field

    Now, the report item design will look like below:

    Preview after adding dimension field

  8. Grouping:

    You can group the added column element with another column by adding the respective dimension element into the Row(s) section.

    Achieve grouping by row values

    Now, the report item design will look like below.

    Preview of row value grouping

  9. Formatting Column and Row(s) sections:

    You can also Filter, Sort, or Group the Column or Row(s) sections using expressions.

    For example, here the Month field is sorted using =Month(cdate("1-" & Fields!Month.Value)) expression.

    Column row settings

    Sorting options

    Set expression

Format Polar Chart

You can format the polar chart for better illustration of the view that you require, through the settings available in the Properties tab.

To format a polar chart, follow the below steps:

  1. Drag and drop the polar chart into the design area and resize it to the required size.

  2. Configure the data for the polar chart.

  3. Focus on the polar chart and click the Properties icon in the configuration panel, the property pane opens.

    Chart Types

You can see the list of properties available for the widget with the default value.

Name

The Name property can be used to provide a unique name for the chart item in the report.

Chart Types

Basic Settings

Chart Types

Show Legend

A Legend is a text used to describe the data plotted. This allows you to toggle the visibility of the legend in chart and also customize the legend text appearance. To set/reset legend properties, refer to the Show Legend property.

Choose Series

You can add multiple series to the chart and the available series will be listed in the Choose Series dropdown. To customize the series appearance, choose the required series name in the dropdown.

Chart Types

We can edit the selected series by clicking the edit button.

Chart Types

Marker Property: In this case, we have enabled the show Marker property and set the Marker type to Diamond and Size(pixel) to 6.000.

Chart Types

Refer to the Series section, to customize each series using the properties panel.

Appearance

The border style, color, width, and background color properties can be used to style the chart and customize its appearance in the report design. These properties are listed under the Appearance category in the properties panel.

Chart Types

Chart Types

Chart Area

The Chart Area property can be used to customize the area of the chart design.

Chart Types

Use the Color Palette property to customize the color of the chart. Color Palette are listed under the Chart Area category.

Here, we have set the Color Palette as EarthTones and the design is shown below.

Chart Types

Title

To show/hide the chart title, toggle the Show Chart Title checkbox. The chart title can be customized by editing the Title Text property of the chart. You can customize the font color, font text, font style, border, background, and position of the title.

Chart Types

Chart Types

No Data

The No Data property is used to display static text when a dataset results with empty or zero rows at runtime.

Chart No data message

To set/reset no data message properties, refer to the No Data Message property section.

Grid line

The Grid line properties can be set to category and value axis.

Chart Types

Category Axis

To show the grid line for the category axis, enable the Category Axis checkbox.

Chart Types

Value Axis

To show the grid line for the value axis, enable the Value Axis checkbox.

Chart Types

Page break

The page break property can be used to control the amount of information on each page when you preview the report. Follow the below steps to apply the page break property for the chart report item.

  1. The Break Location property specifies where the page break should occur. Choose any Break Location type in the drop-down.

    Break location

  2. To restart the page numbering on each page, enable Page Number Reset property checkbox.

    Reset page number

Data Element

Data element can be used to control visibility of a report item when exporting the report in XML format. The Data element properties are listed in the properties panel, under the Data Element category.

Data element properties

Name

You can assign a custom name to the chart element using the Name field. The chart report item will be exported with the provided name.

Data element name property

Note: The name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the underscore character (_).

Output

On exporting the report, the visibility of the chart can be controlled using the Output property. Choosing the following options for the Output property will perform the respective operations:

  • Auto or Output - Exports the chart report item
  • NoOutput - Does not export the chart report item

Data element output property

Miscellaneous

Page name

The page name property is used to name the first worksheet of the Excel workbook when exporting the report to excel format.

Page name property

You can set static or dynamic text as the page name. To set and reset dynamic text, refer to the Set Expression and Reset Expression section.

Tooltip

The Tooltip property can be used to display informative text or values, when the user hovers over the report item in the report preview. To set a tooltip for a chart item using the properties panel, refer to the Tooltip section.

Document Map

A document map is a navigational feature that displays a separate side pane with a set of navigational links in a hierarchical structure when you view a report. A user can click the content in the list to navigate to the report page that displays that item. Refer to the Document Map section to configure the document map in the report design.

You can set static or dynamic text as value for the document map property. To set and reset dynamic text, refer to the Set Expression and Reset Expression section.

Bookmark

Bookmark links allow users to navigate to different parts of a SSRS report. You can add bookmarks to each textbox, image, table or chart or to the unique group values displayed in a tablix which can direct the users to specified locations in the report. The value of the bookmark property can be your own strings or an expression. Refer to the Bookmark section to configure bookmarks in the report design.

You can set static or dynamic text as the value for the bookmark property. To set and reset dynamic text, refer to the Set Expression and Reset Expression section.

Preview report

  1. The final design view of the report is shown below.

    Preview icon in design view

  2. Now, the report preview can be visualized as below.

    Chart report preview

Download the above report design from the link.