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.
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.
Before 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.
Drag and drop a column from Measures
or Dimensions
or Expression Columns
category to Display Columns
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.
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.
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.
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.
Here is an illustration,
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.
Before 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.
Drag and drop a dimension level or hierarchy column under Dimensions
category into Display Column
section.
Define filter criteria through Filter(s)…
menu item in the Settings drop down menu.
Custom sort
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.
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.
Here is an illustration,
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
Enable Multi-select
This allows you to define single/multiple item selection in dropdown list.
Single 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.
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
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
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