ComboBox

ComboBox enables you to filter based on single or multiple items selection in dropdown list. To bind a ComboBox, a minimum requirement of 1 column is needed.

ComboBox control

How to configure flat table data to ComboBox?

The following procedure illustrates data configuration of ComboBox.

Drag and drop ComboBox widget from the Toolbox into design panel and resize into your required size. You can find widget in Toolbox by search.

Drag and drop ComboBox

Before Resizing

Before Resizing

After Resizing

After Resizing

Select the dropped widget using mouse and click the Assign Data button at Design Tools Pane to open the Data configuration pane.

Assign Data

Drag and drop a column from Measures or Dimensions or Expression Columns category to Display Columns section.

Display Columns section

Define the sort order of the dropped column through the Settings drop down menu.

Settings

Define filter criteria through the Filter(s)… menu item in the Settings drop down menu.

Filter criteria

Custom sort

Custom sort

Select the specific item to filter the element and CheckAll is used either to check all the item or to select the specific item. Include and Exclude is used to include and exclude the selected elements. Click the Apply button to apply the selection.

Apply the selection

Select the Condition option to change the Column elements and Summary type by selecting the required column name and summary type.

Column elements

Summary type

Select the Rank option to enable filters and select the Mode as either top or bottom.

Rank option

You can change the Count value to filter the top elements and change the column and summary type as required and click OK button.

Count value to filter

Clear the filters by selecting the Show All Records in the Settings dropdown menu.

Show All Records

Value Column

We can drag and drop a column from Measures or Dimensions or Expression Columns category to Value Columns section.

NOTE

This column section value must be unique.

Display column values will be shown visually in the widget but internal operation based on value column.

Value column will not be applicable for custom format and relative date format.

Value column

Here is an illustration,

Example Given

How to configure the SSAS data to ComboBox?

Following steps illustrates configuration of SSAS data to ComboBox.

Drag and drop ComboBox widget from the Toolbox into design panel and resize into your required size. You can find widget in Toolbox by search.

ComboBox widget

Before Resizing

Before Resizing

After Resizing

After Resizing

Select the dropped widget using mouse and click the Assign Data button at Design Tools Pane to open the Data configuration pane.

Assign Data

Drag and drop a dimension level or hierarchy column under Dimensions category into Display Column section.

Display Column

Define filter criteria through Filter(s)… menu item in the Settings drop down menu.

Filtering criteria

Custom sort

Custom sorting

To know more about filters, refer here.

Define a default measure to the dropped dimension through the Settings dropdown menu against which dimension values need to be categorized.

Settings

Default Measure

Value Column

We can drag and drop a column from Measures or Dimensions or Expression Columns category to Value Columns section.

NOTE

This column section value must be unique.

Display column values will be shown visually in the widget but internal operation based on value column.

Value column will not be applicable for custom format and relative date format.

Value Columns

Here is an illustration,

Example Given

How to format ComboBox?

You can format the ComboBox for better illustration of the view that you require, through the settings available in Properties pane. This pane can be opened from design view through clicking the Settings icon at top right corner of the widget.

Basic Settings

Basic Settings

Enable Multi-select

This allows you to define single/multiple item selection in dropdown list.

Single Selection

Single Selection

Multiple Selection

Multiple Selection

Select Default Item(s) By Index

This allows you to select one or more values by default, based on their corresponding indices mentioned. In single selection mode, you can select only one index and in multi-selection mode, you can select more than one values and also by range.

Indexing Patterns

  • Supports only positive integer values starting from 0.
  • Comma(,) is used to separate the indices. Example: 1,2,5.
  • Hyphen(-) is used to define the index range. Example: 1-4,7,9-11.

NOTE

You can select maximum index value of 100 and selection is not applicable more than 100.
In multi-selection mode, by default the selected indices are sorted to the top order.

select maximum index value of 100

Multi-selection mode

General Settings

General Settings

Heading

This allows you to set title for this ComboBox widget.

SubHeading

This allows you to set sub-title for this ComboBox widget.

Description

This allows you to set description for this ComboBox widget, whose visibility will be denoted by i icon, hovering which will display this description in tooltip.

Filter Settings

Filter Settings

Act as Master Widget

This allows you to define this ComboBox widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.

Ignore Filter Actions

This allows you to define this ComboBox widget to ignore responding to the filter actions applied on other widgets in dashboard.

Container Appearance

Container Appearance

Title Alignment

This allows you to handle the alignment of widget title to either left, center or right.

Title Color

This allows you to apply text color to the widget title.

Show Border

This allows you to toggle the visibility of border surrounding the widget.

Corner Radius

This allows you to apply the specified radius to the widget corners. Value can be between 0 and 10.

Enable Comment

This allows you to enable/disable comment for dashboard widget. For more details refer here