Combo Box

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

How to configure flat table data to Combo Box?

The following procedure illustrates data configuration of Combo Box.

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.

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

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

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

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

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.

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

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

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

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

Here is an illustration,

How to configure the SSAS data to Combo Box?

Following steps illustrates configuration of SSAS data to Combo Box.

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.

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

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

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

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.

Here is an illustration,

How to format Combo Box?

You can format the combo box 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.

General Settings

Header

This allows you to set title for this combo box widget.

Description

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

Basic Settings

Enable Multi-select

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

Single Selection

Multiple Selection

Filter Settings

Act as Master Widget

This allows you to define this combo box 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 combo box widget to ignore responding to the filter actions applied on other widgets in dashboard.

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