Customer clustering Map

  1. Apply page level filters to reduce the volume of data points to below the 1,500 limit when a location field is used (rather than latitude and longitude). In this example, the current year and Southwest region values from the Date and Sales Territory tables, respectively, are used as page level filters.
  2. In report view, add an ArcGIS visual to the canvas and drop the Full Address column into the Location field well.
  3. If the location data points are in one country, click the ellipsis in the top right of the visual and select Edit.
  4. From the Edit menu, click Location Type and then set the Locations are in options to the given country.
Location Type options in ArcGIS maps visual: setting the locations to United States ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.