There's more to experience when you log in!
Lets' get started with Shape Map Visuals!
Launch Power BI Desktop which opens up with a new page. To enable Shape Map, select File > Options and Settings > Options > Preview Features, then select the Shape Map Visual checkbox. Click "OK".
Restart Power BI Desktop to enable the Shape Map Visual icon under the Visualizations Pane.
Once Shape Map is enabled, select the Shape Map icon from the Visualizations pane. Power BI Desktop creates an empty Shape Map visual design canvas.
Select geographic data field* of interest on which Shape Map will be created. Drag geographic data field to the Location field under Visualizations Pane [In this example, County_fips (US County FIPSCode) is used as geographic field]. The United States shape map is created by default. Color saturation field holds information on which Thematic will be created [In this case Fill Rate % information for each county].
*Geographic Data Field – In PowerBI, several data categories exists to classify the data type. Geographic data field is the one which when mapped with PowerBI internal geocoder, it assigns a coordinate reference to the admin/place/address information. A globe icon is created next to these fields when mapped with PowerBI Geographic Data categories.
In "Format" tab of the Visualization pane, click "Shape" option. Under Map, a dropdown list of various preconfigured Shape map is displayed and "USA : states" map lies on the top and set as default for Shape Map. This is the reason; we see a default shape map created for the United States for any data field loaded for the first time.
So, a custom map needs to be created which we can add to the existing list. To add a custom Map, "+ Add Map" option is available which needs a TopoJSON file as input. The TopoJSON file should contain the boundary definition of a map region. The shape map visual make use of the TopoJSON file to generate the custom map.
US County data is available with Syncsort and can be easily downloaded from Software and Data Marketplace. Software and Data Marketplace is one stop shop to discover, visualize, try and download all your data needs.
Download US Census boundaries in shape/tab format whichever is convenient to use and extract county file from the bundled product.
Zip the US county shapefile/tab file (including all associated files*).
*Tab File Zip
If geometries are very detailed (as seen in below map), you can simplify the geometry using simplify option in mapshaper URL. Simplification of geometry helps in faster rendering as it reduces the number of nodes. The geometry might get a little distorted with simplification process, but it depends on user's discretion what detailed level of geometry they plan to display as background/basemap.
Click Export option to export the file in TopoJSON format.
TopoJSON file is now ready to be imported in PowerBI (a snippet of how TopoJSON file look like).
Important: To map data to your shapes in Power BI, keep the same field record name as they are in your data. For example, if in your data you have a [County FIPS] field and it has a value of "01001", you want to name the Polygon shape as "01001" if that's the field you plan to bind to your map's location property. This is important for better mapping of map keys.
Now go to Fields pane, drag Fill Rate value Field into "Color saturation" option to create custom thematic map. You will see county level fill rate thematic created for roof cover [sample data field used to illustrate Thematic here]. Additionally, you can add Legend field to further define the value under color saturation option.
So, what are you waiting for? Explore and Learn new functionality with LI Boundaries data and feel free to reach out if you need any help!
The shape map is visually wonderful to play around with but currently it's not very user-friendly, not quite responsive to changes done at runtime. The page has difficulty in zoom in/zoom out and it loads slowly. The shape map does not show the map keys of the currently selected map. In addition, you must also have the Color saturation bucket set in order for the Legend classification to work properly. The Shape Map currently can plot up to a maximum of 1,500 data points only
[Article is based on PowerBI Version: 2.79.5768.1082 64-bit (March 2020) and US county data 2019.05]