Build your first map

This tutorial takes about 15 minutes. You start with an empty visual and a ten-row table of European capitals, and finish with a map of circles sized and colored by sales, with labels and tooltips, that filters the rest of the report page.

Before you start

You need:

• Power BI Desktop, with Icon Map Lite added to your report. See Add Icon Map Lite to a report.
• An Icon Map Lite license assigned to you. The free one-month trial from Microsoft AppSource is enough. See How Icon Map Lite is licensed.

Step 1: Create the sample data

1. In Power BI Desktop, select Home > Enter data.
2. Copy the table below, select the first cell of the grid in the Create Table window, and paste.
3. If Power BI does not pick up the column names, select Use first row as headers.
4. Name the table Stores and select Load.

Expected result: a table named Stores appears in the Data pane with five columns. Latitude, Longitude and Sales show the sum symbol, which tells you they are numbers.

Step 2: Add the visual

1. Select the Icon Map Lite icon in the Visualizations pane.
2. Drag a corner of the new visual so it fills most of the page, leaving some room on the right for a table in Step 9.

Expected result: the visual shows the Icon Map Lite start page over a moving world map, with a Get started panel. On a large visual the start page also shows example maps.

Step 3: Add the fields

Keep the visual selected and drag fields from the Stores table into the field wells in the Build pane, in this order.

1. Drag City to * ID (required).

   Expected result: the start page is replaced by a panel titled What kind of map are you making?. It tells you that only the ID is filled in so far. This panel is the layer guide. It appears whenever your rows do not reach a layer yet.

   If you have no license, a page headed "Get Icon Map Lite to see this map" appears instead. Start the free trial or ask for a license to be assigned to you, then reopen the report.

2. Drag Longitude to Longitude (X) and Latitude to Latitude (Y).

3. In each of those two field wells, select the arrow next to the field and choose Average.

   Expected result: the layer guide stays, and now says that Circles is turned on, but also needs Circle Size. Point to the Circles tile to see the fields it needs, with a tick next to the ones you have added. The card opens over the tile and, on a short visual, can cover the summary at the top of the guide.

   

4. Drag Sales to Circle Size.

   Expected result: the guide closes and the map appears. It zooms to fit ten circles across Europe, larger where sales are higher.

Your field wells now look like this:

Step 4: Style the circles

1. Open the Format pane and expand the Data Layers card. In its first group, Data Layers, the Circles switch is already on.
2. Expand Circles - Configuration. Leave Size Behavior on Relative, and set Minimum Size to 8 and Maximum Size to 40. These are the sizes of the circles with the smallest and largest value.
3. Expand Circles - Formatting. Set Outline Color to white (#FFFFFF) and Outline Width to 1.

Expected result: the circles now range from small to large with a thin white outline.

Step 5: Color the circles by sales

Fill Color sets one color for every circle. To take the color from your data, use conditional formatting.

1. Stay in Data Layers > Circles - Formatting.
2. Next to Fill Color, select the fx button.
3. In the Power BI dialog, set Format style to Gradient and choose Sales as the field to base it on. Pick a light color for the lowest value and a dark color for the highest.
4. Select OK.

Expected result: each circle takes a color between your two colors. London, with the highest sales, is the darkest, and Dublin the lightest.

Most color, size and visibility settings accept conditional formatting. See Conditional formatting.

Step 6: Choose a background map

1. In the Format pane, expand the Background Layer card and its Map group. Background map is set to Light.
2. Change Background map to Mono light, a gray version of the map.
3. In the Map labels group, switch off Towns and cities, so that the map's own city names do not compete with the labels you add in the next step.

Expected result: the map is now gray, and the colored circles stand out against it.

The world map is built into the visual, so changing it downloads nothing. See The background map for the other themes and detail switches.

Step 7: Add labels

1. In the Format pane, expand the Labels card and its Content group.

2. Set Display Label to Yes.

3. Next to Label Text, select fx. Set Format style to Field value, choose City as the field, and select OK.

   Expected result: each circle shows its city name in a box, centered on the circle.

4. In the Style group, set Label Style to Halo Text.

5. In the Placement group, set Position (circles & images) to Above.

Expected result: the names sit above the circles as plain text with a white halo, which keeps them readable on any background map.

See Data labels for the other label styles and options.

Step 8: Add tooltips

1. Drag Category to the Tooltips field well.
2. Drag Sales to Tooltips as well.
3. Point to a circle on the map.

Expected result: a tooltip lists the category and the sales for that city. When the Tooltips field well is empty, the tooltip shows the ID and the circle size instead. See Tooltips.

Step 9: Filter the report

Icon Map Lite filters the other visuals on the page the way a slicer does.

1. Select an empty part of the report page, then select Table in the Visualizations pane.

2. Add City and Sales from the Stores table to the new table.

3. Select the London circle on the map.

   Expected result: the table shows only London. On the map, London stays solid and the other circles fade.

4. Hold Ctrl or Shift and select the Paris circle. The table now shows both cities.

5. Select an empty part of the map. The filter is cleared and the table shows every city again.

The filter stays in place when you select something in another visual, and a bookmark saves it with the rest of the page. To select several circles at once with a lasso or a circle, turn on Lasso or Circle Select in Format pane > Selection > User Selection. See Select and filter with the map.

Step 10: Try it out

• Zoom and move. Scroll to zoom, drag to pan, and use the + and - buttons at the top left.
• Switch to a globe. Select the globe button on the map. Select it again for the flat map.
• Use the keyboard. Press Tab until the map is outlined, move between circles with the arrow keys, and press Enter to select one.

What you have learned

• A row is drawn when it fills in the fields its layer needs. For circles these are * ID (required), Longitude (X), Latitude (Y) and Circle Size.
• The layer guide tells you what is missing while nothing is drawn.
• Each layer has a switch in Format pane > Data Layers, followed by its configuration and formatting groups.
• Conditional formatting (fx) takes a color, a size or a label from your data.
• Selecting on the map filters the rest of the report page.

Next steps