List Box

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

List Box control

How to configure the flat table data to ListBox?

The following procedure illustrates data configuration of ListBox.

Drag and drop List Box control icon from the Tool box into design panel. You can find control in Toolbox by search.

List Box control icon

Before Resizing

Before Resizing

After Resizing

After Resizing

After control added in design panel, click Assign Data button at Design Tools Pane to open the Data configuration pane.

Assign Data

Bind column through drag and drop element from sections to Display Column section.

Display Column

You can select the settings to sort the data either Ascending or Descending.

Settings to sort

Custom sort

Custom sort

You can use the filters by selecting the Filter(s)… option to rank the elements.

Filter option

You can select the specific city to filter the element and CheckAll is used either to check all the data or to select the specific data. Include and Exclude is used to include and exclude the elements by selecting the radio button and click the Apply button.

Include and Exclude

You can 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

You can select the Rank option to enable filters and select the Mode 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 option

You can clear the filters by selecting the Show All Records option.

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 ListBox?

Following steps illustrates configuration of SSAS data to List Box.

Drag and drop ListBox control icon from the Tool box into design panel. You can find control in Toolbox by search.

ListBox control icon

Before Resizing

Before Resizing

After Resizing

After Resizing

After control added in design panel, click Assign Data button at Design Tools Pane to open the Data configuration pane.

Assign Data

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

Display Column

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

Filtering criteria

To know more about filters, refer here

Define default measure to the dropped dimension through Default Measure menu item to retrieve exact result for that dimension.

Default Measure

ssas_listbox

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 format ListBox?

You can format the List 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

General Settings

Header

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

SubHeading

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

Description

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

Basic Settings

Basic Settings

Enable Multi-select

This allows you to define single/multiple item selection in List Box.

Single Selection

Single Selection

Multiple Selection

Multiple Selection

Filter Settings

Filter Settings

Act as Master Widget

This allows you to define this list 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 list box 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