Add location-based data from your Power BI datasets to an ArcGIS Maps for Power BI visualization to tell a story about your data. Add size and color values to view your data in a different light or add other values to help your map tell your story.
Before you add location data to a map, be sure that your data is appropriately configured for use with ArcGIS Maps for Power BI; for details, see Prepare your data.
Add location data to a map
To view location data on an ArcGIS Maps for Power BI visualization, do the following:
- In the Fields pane, expand the dataset with which you want to work.
- In the Visualizations pane, if the Fields tab is not already selected, click the tab to show the map's field wells.
- Click a location-based field and drag it over the map.
Alternatively, you can drag field values in the Location or Latitude and Longitude field wells in the Visualizations pane. For detailed information about location types, see Location types and data formats.
- Location—Drag a location-based value from your data fields into this field well to display the features on the map.
- Latitude—Drag a latitude (y) value from your data fields into this field well to define part of a map coordinate. If you use this field, you must also specify the corresponding longitude (x) field.
- Longitude—Drag a longitude (x) value from your data fields into this field well to define part of a map coordinate. If you use this field, you must also specify the corresponding latitude (y) field.
If your data contains latitude and longitude values, use these to accurately plot your data on the map. If you fill the Location, Latitude, and Longitude field wells, ArcGIS Maps for Power BI uses the Latitude and Longitude fields to map your data and ignores the Location field. For more information about location fields, see Location types and data formats.
ArcGIS Maps for Power BI displays the locations on the map using default styling.
Add other data to the map
ArcGIS Maps for Power BI provides other, nonlocation fields that let you control the way features appear on the map. The following fields are available:
- Find Similar
Unlike location-based field wells, you can add data to some, none, or all the fields described here to change the story your map tells.
It is a best practice to add location-based data—either location or latitude and longitude fields—to the map before adding other fields. In some cases, if you add size, color, or both size and color fields to the map before adding latitude and longitude fields, ArcGIS Maps for Power BI tries to summarize the latitude and longitude values, resulting in points not rendering on the map.
Add numerical values to the Size field well to draw features on the map according to size. For example, if your map shows store locations, drag a profit field into the Size field well; the map automatically renders location symbols in proportional sizes, according to profit value.
Depending on the fields you choose, the map automatically updates its theme and styling to display a more accurate picture of your data.
Add numerical data to the Color field well to distinguish features on the map based on a color ramp. For example, a light-to-dark color ramp is useful for showing low-to-high data values such as revenue or income.
You can also add categorical data to show features using different colors; for example, use different colors to represent customer language preference.
Size and Color
Choose two attributes in your data to define both the color and the size of point symbols on your map. You can also use the same attribute twice: to set the size of the symbols, and to set the colors, based on the part of the data you want to emphasize. This is useful if you want to show count information, such as the number of female single-parent households, shaded by a rate, such as the rate of female single-parent households.
You can further customize the map by editing its basemap and styling options; for more information, see Edit the map contents. You can also modify the visualization itself in the same way you would with any other Power BI visualization; see Format the map visualization for more information.
Drag a field containing temporal data (date, time, or date and time) into the Time field well to animate the features on the map according to time.
For more information, see Map time-aware data.
Drag categorical or numeric fields into the Tooltips field well to define the information that appears in tooltips. You can drag multiple fields into the field well.
You can drag the same field into the field well multiple times and apply a different aggregation option to each one. For example, you could drag a numerical field into the Tooltips field well three times, and calculate the SUM for one, AVG for another, and MIN for the third. Each of the fields will appear in the tooltip, with the appropriate label and value.
When you hover over a feature on the map, a tooltip appears, displaying information specific to that feature.
In tooltips, fields appear in the order you added them to the field well.
The Find Similar feature lets you analyze the data on your map and identify the locations that are most similar to the ones you currently have selected. For more information, see Find similar features.