Bubble Map

Bubble Map allows you to showcase quantitative values encoded through bubble size.

How to configure flat table data to Bubble Map?

To plot a Bubble Map, a minimum requirement of 1 value and 1 shape is needed.

The following procedure illustrates data configuration of Bubble Map.

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

dragging bubble map from toolbox to design canvas

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

focused view of dropped bubble map in design canvas

Bind column through drag and drop element from Measures section to Value.

dragging measure element to value section

Drag and Drop the elements from sections to Shape.

dragging dimension element to shape section

You can use the aggregation function to change the Value of the column.

changing aggregation type for a value element

You can use the filter option to enable the Filters by selecting the Edit option.

edit filter option highlighted in value column settings menu

Measure Filters window will be shown to select filter condition.

measure filter window showing comparison operators list

You can clear the filter by selecting the Clear option.

clear filter option highlighted in value column settings menu

You can format the values by selecting the Format option.

format option highlighted in value column settings menu

Measure Formatting window will be shown.

measure formatting window

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

filter option highlighted in shape column settings menu

You can select the specific country 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.

dimension filters window with list dropdown opened

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

column list shown in condition section of dimension filters window

summary list shown in condition section of dimension filters window

You can select the Rank option to enable filters and select the Mode either top or bottom.

ranking of values

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 of values to filter

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

show all records option highlighted in shape value settings menu

Here is an illustration,

bubble map view

How to configure SSAS data to Bubble Map?

To plot a Bubble Map, a minimum requirement of 1 value and 1 shape is needed.

Following steps illustrates configuring SSAS data to Bubble Map.

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

dragging bubble map from toolbox to design canvas

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

focused view of dropped bubble map in design canvas

Drag and drop a column under Measures category into Value.

dragging measure element to value section

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

dragging dimension element to shape section

Define the filter criteria to match through choosing Edit option in Filter menu item.

edit option highlighted in value column settings menu

The Measure filter dialog will be shown where you can choose the filter condition and apply the condition value.

measure filter window showing comparison operators list

Select Clear option to clear the defined filter.

clear option highlighted in value column settings menu

Select Format option to define the display format to the values in the column through Measure Formatting window.

measure formatting window

Choose the options you need and click OK.

measure formatting window with currency type applied

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

dragging dimension element to shape section

Select Filter(s)… to launch the Filters window.

dimension filters window

Define the filter Condition and Rank and Click OK.

dimension filters window with condition and rank settings configured

To show all records again click on Show All Records.

show all records option highlighted in shape value settings menu

Here is an illustration,

bubble map view

How to format Bubble Map widget?

You can format the Bubble Map for better illustration of the view that you require, through the settings available in Properties pane.

General Settings

general settings section in properties window

Heading

This allows you to set title for this Bubble Map widget.

SubHeading

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

Description

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

Basic Settings

basic settings section in properties window

Enable Navigator

You can enable/ disable the map navigator in Bubble Map.

Bubble Color

You can customize the bubble color from the set of predefined color palette.

bubble color setting in properties window

Show Data Labels

You can enable or disable the data labels in map widget by using Show Data Labels property. After enabling this property, a dropdown menu is enabled for choosing the shape properties (i.e. name, admin, iso_3166, etc.) which is going to be displayed as data label.

data labels display format

The properties displayed in the DropDownList are changed based on selected shapes.

Filter Settings

filter settings section in properties window

Act as Master Widget

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

Enable Multi Selection

Enable Multi Selection is displayed only when you enable the Act as Master Widget option. This allows you to select multiple shapes in the Bubble Map widget.

filter section in properties window

Link Settings

You can enable linking and configure to navigate either to a published dashboard URL or to a general URL with or without parameters. For more details, refer Linking.

Container Appearance

container appearance section in properties window

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.

Show Maximize

This allows you to enable/disable the maximized mode of this Bubble Map widget. The visibility of the maximize icon in widget header will be defined based on this setting. Clicking this icon in viewer will show the maximized view of the Bubble Map widget.

CSV Export

This allows you to enable/disable the CSV export option for this Bubble Map widget. Enabling this allows you to export the summarized data of the widget view to CSV format.

Excel Export

This allows you to enable/disable the Excel export option for this Bubble Map widget. Enabling this allows you to export the summarized data of the widget view to XLSX format.

Image Export

This allows you to enable/disable the image export option for this Bubble Map widget. Enabling this allows you to export the view of the widget to image format (*.JPG) in viewer.

Enable Comment

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

Map Settings

map settings section in properties window

Built-in

You can choose from the available 14 map shape files shipped along with dashboard designer for visualizing map data.

Custom

This option allows you to load any map shape files (i.e. .json files) into Bubble Map widget. For loading custom map files, you need to choose Custom option from Map settings. After enabling this option, browse icon is enabled for loading custom shape file.

custom option highlighted under map settings section

Using browse icon, we can browse and load the required shape file in Map.

custom shape file path highlighted under map settings section

Columns

You can choose multiple column fields from the list of field names supported by the loaded map shape that can be mapped with the data source connected. By default all column fields have been selected and you can select/unselect from columns drop down menu.

columns listing under map settings section