Style data with counts and amounts by size


You need the following account and license types to use this workflow:

  • Microsoft license—You need a Microsoft 365 license, role Contributor or higher, to apply a style to data.
  • ArcGIS account type—Standard users can perform the functions of this workflow; you do not need to sign in.

You can use graduated symbol sizes to represent numeric data or ranked categories, allowing you to visually compare quantities and identify trends.

See Data styles to learn about data style options and Smart map styles to learn about smart map cards.

In maps styled with proportional symbols, larger symbols represent larger numbers. Adjust the size of the symbols to define the data. For example, you can use proportional symbols to show the total population surrounding public library locations in Iowa as shown in the following image:

Counts and amounts by size styling on a map
Refer to Smart Mapping: Counts and Amounts (size) for more information about styling with proportional symbols.


Add numeric data to the Size column or field well before you begin.

To style data using counts and amounts by size, complete the following steps:

  1. Follow the steps in the Apply a style workflow for your component:

    If the ArcGIS for Power BI mapped locations are represented by polygons and you add a numeric value to the Size field well, the map updates to show graduated symbols with the symbol in the center of the area defined by the original polygon.

  2. At the choose a smart map style step, choose the Counts and Amounts (size) style card.
  3. Hover over the style card and click Style options Style options to customize the look of the layer.

    The layer updates to style counts and amounts by size, and the style options appear.

  4. Define the style options by doing any of the following:
    • Expand Symbology and specify the symbol settings to change the style of the proportional symbols (shape, fill, and outline).
    • Expand Classify data.
    • If the data isn't normalized or standardized, choose an attribute field from the Divided by drop-down menu to turn the raw data into rates or percentages. Examples of normalized data include x per capita, y per square kilometer, or a ratio of x to y. Raw counts, by comparison, are better visualized with colors after they are standardized.

      The Divided by menu is not available in ArcGIS for Power BI.

    • Adjust the bounding handles along the histogram in Classify data to change how the proportional symbols are applied to the data. You can either drag the handle or click the number next to the handle and type a value. All values above the upper handle are drawn with the same largest symbol. Values below the lower handle are displayed with the same smallest symbol. The remaining values are drawn with a proportional sequence of sizes between the bounds. Experiment with the position of the handles and use the histogram to see the distribution of the data and fine-tune the way these values with size appear on the map.
    • Turn on the Classify data toggle button, choose the classification method, and specify the number of classes to further generalize the map, or if you are using standard deviation, choose the interval.
    • Turn on the Show features with no value or out of range toggle button to draw locations with missing data on the map, and, optionally, specify a style and label to represent those values.
    • Expand Size range. To optimize symbols for the current zoom level and automatically adjust them at other zoom levels, choose Automatic. To set a custom zoom level, click Custom and set a Size range in px value by adjusting the slider handles or clicking the default values and providing new values.
    • Expand Transparency, turn on the Enable Transparency toggle button, and specify the transparency settings.
    • Expand Rotate symbols, turn on the Use rotation toggle button, and specify the rotation settings.

      The Rotate symbols and Transparency option are not available in ArcGIS for Power BI.

  5. Click the Back button Back to close the pane and view the Layers list.