Configuring and Formatting Bing Maps

Bing Maps allows you to visualize the markers based on the latitude and longitude data.

Figure: Default Bing maps visualization showing markers based on the configured latitude and longitude information

How to get Bing Maps keys

You need to follow these steps to get keys.

1. Go to the Bing Maps Dev Center at https://www.bingmapsportal.com/.

2. Register or sign in using your Microsoft account.

3. Select My keys under My Account.

4. Select the option to create a new key.

5. Provide the required details in the following form,

6. Click the Create button. The created new key will be displayed in the following list. Use this key to authenticate your Bing Maps.

How to enable Bing Maps by configuring the web config file in Enterprise

To enable the bing maps in your enterprise build, you need to follow these steps.

Bold BI version 4.1.36 or later

Open the below mentioned file in your enterprise build location,

[Installed_Directory \BoldServices\bi\dataservice\appsettings.json].

Set widget:bing_map:enable key value as true and set your Bing Maps Key in widget:bing_map:api_key in appsettings.json.

Then, launch your build and you find the bing maps in design panel.

Bold BI version below 4.1.36

1. Open the following file in your enterprise build location,

[Installed_Directory\ Bold BI\Dashboard Designer\Web.config]

2. Set the widget:bing_map:enable key value to true.

3. Provide your bing maps key here.

Then, launch your build and you can find the bing maps in the design panel.

How to configure the data table to Bing Maps widget

NOTE: Before adding the Bing maps widget to the design layout, make sure to create the data source. You can refer to this section to learn how to create a new data source.

IMPORTANT: To showcase a Bing maps, a minimum requirement of one latitude and one longitude fields are needed.

The following steps explains about data configuration of the Bing maps.

Step 1: Add a bing maps widget to the design canvas

1. Drag and drop the Bing maps control icon from the toolbox into the design panel. You can find control by searching in the toolbox.

2. Resize the widget as required.

Step 2: Configuring data into the widget

1. Click the Properties icon in the configuration panel.

2. The properties panel of the widget will be displayed as shown in the following screenshot. Now, switch to the ASSIGN DATA tab.

3. The data tab will be opened with available columns from the connected data source.

Location Value

An element can be dragged from the measure or dimension section.

Location Name

Drag the elements from the Dimension to Location Name section.

Bing map will render as follows.

You can add more than one value to the Location Name section. The alert message will be shown to enable the drill-down option.

Click Yes to enable the option.

NOTE: If you click No, a single value will be added to the Location Name field(i.e. newly dropped column replace the existing one).

Figure: Bing-map with drilled view of the selected area.

Latitude Section

Bind column by dragging and dropping the element from sections to Latitude.

NOTE:

• The field added in this section will act as a latitude value.

Longitude Section

Drag and drop the elements from sections to Longitude section.

NOTE:

• The field added in this section will act as a longitude value.

Image: Bing maps widget after configuring the mandatory fields.

Address

Drag and drop the elements from sections to Address section. The field added here, will act as a address value.

Bing maps widget, after configuring the Address fields.

Postal Code

Drag and drop the elements from other sections to Postal Code section. The field added here, will act as a postal code.

Image: Bing maps widget after configuring the Postal Code fields.

Marker Tooltip section

Drag and drop the elements from sections to the Marker Tooltip section. It will define the marker tooltip value in the bing maps. Also, it is an optional section.

Image: Bing maps widget after configuring the market tooltip field

Marker Image section

Drag and drop the elements from sections to the Marker Image section. It will define the marker in the bing maps. Also, it is an optional section.

Image: Bing maps widget after configuring the marker Image field

Step 3(Optional): Settings menu options

You can filter and sort the data displayed in the widget from the settings menu options. To open the settings menu, click the settings icon.

Filtering data

You can use Filters to change the values by selecting the Filter option. For more details, refer to Measure filter and dimension filter.

How to format Bing maps widget

You can format the Bing maps for better illustration of the view that you require using the settings available in the Properties tab.

General settings

Name

This allows you to set title for this Bing maps widget.

Subtitle

This allows you to set subtitle for this Bing maps widget.

Description

This allows you to set brief explanation about this Bing maps widget.

Basic Settings

Map theme

This allows you to toggle the theme of the bing maps.

1. Road Type

2. Aerial

3. Canvas Dark

4. Canvas Light

5. Gray Scale

Show Zoom Icon

This allows you to show the zooming icons in bing maps.

If you perform zoom in or zoom out using icons or mouse in design mode, then the same zoom level will be maintained in the view mode.

Zoom state in design mode.

Zoom state in view mode.

Disable Zooming and Panning

This disables the Zooming and Panning in maps.

Map shape

This allows you to toggle the map shapes of the Bing Maps.

1. Choropleth

2. Bubble

Formatting

This section shows up when the Location Value and Location Name fields have values.

Monochromatic

You can configure a single color palette whose saturation differs based on the value density.

Advanced Settings

This allows you to customize the map color with three different types: gradient, rule, or individual. By default, the window renders with gradient type.

If you enable the option Advanced, the color customization window will render as follows.

Gradient

You can select the desired measures or dimensions field using the Based On dropdown. You can change the summary type. You can edit the Low and the High value and their colors. By default, the low value takes the minimum value of the map and the high value takes the maximum value of the map. The Mid can be enabled and can change its value and color can be changed. By default, the mid-color is disabled.

If you click save, the map will render as follows.

Default color

The default color will apply for conditions not satisfied by the advance color customization.

Rule

You can select the rule settings by clicking the Rule radio button. The color customization window renders as follows.

You can change Based on field and summary type as gradient type. The Value Type can be changed with value or percentage.

You can choose a series of colors with the Fill color picker using the multiple condition sets: greater than, less than, equal to, not equal to, between, Not between, greater than or equal to, and less than or equal to. You can customize the legend name by providing the necessary values inside the condition name. You can also add multiple conditions.

Individual

You can select the rule settings by clicking the Individual radio button. The color customization window renders like this.

This type renders with the individual default color for each value of the map. You can change its color with the individual color pickers. If you want to reset your changes return to the default color using the Reset.

You can save your changes by clicking the Save. Now, the map renders with changes.

Marker Settings

Marker Shape

This allow to change the marker shapes of the bing maps.

1. Circle

2. Diamond

3. Star

4. Triangle

5. Image

This allow to upload the various type of Images.

Image: Bing maps widget after applying the marker Image settings

Color

This allows to change the marker color of the bing maps.

Size

This allows to change the marker size of the bing maps.

Advanced Settings

Markers can be customized based on the conditions and the fields by enabling the advance settings check box.

1. Based on the measure field.

2. Based on the dimension field.

Link

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

To Configure Bing maps with address information

You can render the bing maps markers based only on the address information. For that, there are two sections Address and Postal Code added in the field containers section as shown in the following image,

Drag and drop the required fields to the respective field containers to render the bing maps markers. You can drag and drop either the Address field or Postal Code field, or both the fields.

After that configurations

Filter

Act as master widget

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

Enable hierarchical filtering

Using this option, you can enable or disable hierarchical the top N filtering. While applying the Top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering needs to be done as flat or based on the hierarchy of dimension columns added.

When the Hierarchical Filter option is enabled, the Top N will be applied for each individual column separately based on the number set for each column.

Container appearance

This section contains the property for bing maps container’s layout.

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 the text color to the widget title.

Title Auto Font Size

On enabling Auto Font Size, the font size of the title will be adjusted automatically if the resolution of the screen varies.

Font Size

This allows you to apply the specified size of the font to the widget title if the Title Auto Font Size is disabled. Value can be between 10 and 44.

Subtitle Auto Font Size

On enabling Auto Font Size, the font size of the subtitle will be adjusted automatically if the resolution of the screen varies.

Font Size

This allows you to apply the specified size of the font to the widget title if the Subtitle Auto Font Size is disabled. Value can be between 10 and 32.

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 if the Show Border is enabled. Value can be between 0 and 10.

Show Background Image

This allow you to set the background image for the map widget.

Background Color

This allows you to set the background color to the map widget.

Transparency

This property allows you to change the transparency from 0.0 to 1.0.

Container actions

Show Header

This allows you to enable or disable the widget title of the map.

Allow Maximize View

This allows you to enable or disable the maximized mode of the map widget. The visibility of the maximize icon in the widget header will be defined based on the setting in the viewer.

Allow CSV Export

This allows you to enable or disable the CSV export option for the map widget. Enabling this allows you to export the summarized data of the widget view to CSV format in the viewer.

Allow Excel Export

This allows you to enable or disable the Excel export option for the map widget. Enabling this allows you to export the summarized data of the widget view to (.xlsx or .xls) format in the viewer.

Allow Image Export

This allows you to enable or disable the Image export option for the map widget. Enabling this allows you to export the view of the widget to image format (.jpg), (.png), or (.bmp) in the viewer.

Allow PDF Export

This allows you to enable or disable the PDF export option for the map widget. Enabling this allows you to export the view of the widget to pdf format in the viewer.

Enable Comments

This allows you to enable or disable comment for the dashboard widget. For more details, refer to this link.

Allow View Underlying Data

This allows you to visualize the raw data associated with a widget at runtime.

To learn more about viewing the underlying widget data, refer to the view data documentation.

Pin Widget

This allows you to pin the widget.