Chart Field

The Chart Field is utilized to display various types of charts for visualizing data without needing to sync with a PowerBI report. Each chart requires a target to fetch and display the relevant data.

There are 18 types of charts to chose from, and each chart can be set to a categorical or numerical axis type. A categorical axis type allows for a string or date on one axis and a value for the other axis, and the numerical axis type allows for a numeric value or date for both axes. The axes’ can be formatted to display the values in a specific format.

Tooltips can be added to the chart to provide detailed information when hovering over the chart.

Charts can include a search component, offering greater flexibility in data display.

Screenshot of two types of chart fields: bar chart and pie chart

Where Do We Get the Data for This Control?

Contains the target information of the target that will be called to get the series chart data.

Chart data consists of a series or a set of series. In the example below, the chart contains two series: Product one and Product two.

Chart Title

The title that will be displayed above the chart.

Enable Data Auto Refreshing

Determines if the data will refresh automatically after a specified period of time.

Every How Many Minutes Should the Data Refresh?

Only applicable when “Enable Data Auto Refreshing” is set to “Yes”.

Specifies the interval in minutes for automatically refreshing the chart data.

Add Search Component?

This is an advanced feature and requires custom TSQL. Search Components are only applicable when Custom Data is selected. If a search component is defined, a TSQL procedure must also be selected.

The search component will appear at the top of the Field, and the user will be able to use it to filter the data.

Chart Type

Determines the type of chart that will be displayed.

Enable Chart Tooltips

Determines if tooltips will be enabled on the chart. Tooltips are displayed when you hover over a data point on the chart and specific detailed information about that point will be displayed.

Legend Position

Determines where the legend will be displayed in relation to the chart.

Axis Type

Only applicable when “Chart Type” is set to “Area”, “Bar”, “Bubble”, “Candlestick”, “Column”, “Line”, “OHLC”, “Radar Area”, “Radar Column”, “Radar Line”, “Range Area”, “Range Bar”, “Range Column”, “Scatter”, “ScatterLine”, or “Waterfall”.

Determines the type of axis that will be used.

Categorical: The choice between a Category (string value) or Date axis for one of the axis, and a value axis for the other.

Screenshot of a bar chart with a categorical axis type

Numerical: The choice between a Date or Numeric (number value) axis for both axes.

Screenshot of a bar chart with a numerical axis type

Category Axis Type

Only applicable when “Axis Type” is set to “Categorical”.

Determines what type of data will be on the axis.

Category: A string value (example: group A).
Date: A date (example: 01/01/2020).

Value Title

Only applicable when “Axis Type” is set to “Categorical”.

Determines the title on the Value Axis.

Category Title

Only applicable when “Axis Type” is set to “Categorical”.

Determines the title on the Category Axis.

Value Format

Only applicable when “Axis Type” is set to “Categorical”.

Determines the formatting of data on the Value Axis.

Refer to Microsoft’s Standard Numeric Format Strings for a formatting guide.

Category Format

Only applicable when “Axis Type” is set to “Categorical”.

Determines the formatting of data on the Category Axis.

Refer to Microsoft’s Standard Numeric Format Strings for a formatting guide.