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.
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.
Before Resizing
After Resizing
After control added in design panel, click Assign Data
button at Design Tools Pane to open the Data configuration pane.
Bind column through drag and drop element from sections to Display Column
section.
You can select the settings to sort the data either Ascending
or Descending
.
Custom sort
You can use the filters by selecting the Filter(s)…
option to rank the elements.
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.
You can select the Condition
option to change the Column
elements and Summary
type by selecting the required column name and summary type.
You can select the Rank
option to enable filters and select the Mode
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.
You can clear the filters by selecting the Show All Records
option.
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 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.
Before Resizing
After Resizing
After control added in design panel, click Assign Data
button at Design Tools Pane to open the Data configuration pane.
Drag and drop a dimension level or hierarchy under Dimensions category into Display Column
.
Define filter criteria through Filter(s)…
menu item in the Settings drop down menu.
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.
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 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
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
Enable Multi-select
This allows you to define single/multiple item selection in List Box.
Single Selection
Multiple Selection
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
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