{"id":16473,"date":"2024-06-18T09:56:11","date_gmt":"2024-06-18T02:56:11","guid":{"rendered":"https:\/\/fpt-is.com\/en\/?post_type=goc_nhin_so&p=16473"},"modified":"2024-07-26T09:35:30","modified_gmt":"2024-07-26T02:35:30","slug":"uses-of-shape-maps-in-power-bi","status":"publish","type":"goc_nhin_so","link":"https:\/\/fpt-is.com\/en\/insights\/uses-of-shape-maps-in-power-bi\/","title":{"rendered":"Uses of Shape Maps in Power BI"},"content":{"rendered":"

The Shape Maps feature in Power BI is not only a charting tool but also an effective method for displaying regional data insights. With the ability to create rich and powerful geographic charts, Shape Maps <\/b>adds<\/b> a new feature to data visualization and analysis in Power BI.<\/b><\/p>\n

1. Uses of Shape Maps in Power BI<\/b><\/h2>\n

In creating reports using data visualization tools, illustrating data using maps has become a routine task, particularly for comparing data between regions. The simplest way to accomplish such tasks is to use <\/span>Shape Maps<\/b>. Unlike commonly used <\/span>Maps<\/b>, a <\/span>Shape Map <\/b>cannot display the exact geographic locations of data points on the map. Instead, its main purpose is to compare regions on a map by coloring them differently.\u00a0<\/span><\/p>\n

\"M<\/p>\n

Figure 1 \u2013 Current status of land use in each region and province of Vietnam<\/span><\/i><\/span><\/p>\n

\"M<\/p>\n

Figure 2 – Land statistics of districts in Da Nang<\/span><\/i><\/span><\/p>\n

When moving the mouse over an area or selecting an area, the displayed descriptions, as well as other display areas of the report, also change corresponding to the selected object.<\/span><\/p>\n

This article shares the author’s knowledge of using <\/span>Shape Maps <\/b>in <\/span>Power BI<\/b>, searching for Vietnam’s national administrative map, as well as adjusting the content, scope, and quality of the map.<\/span><\/p>\n

2. Using Shape Map in Power BI<\/strong><\/h2>\n

Shape Maps<\/b> are not available by default in <\/span>Power BI Desktop<\/b>. You need to enable the feature by selecting <\/span>File > Options and Settings > Options > Preview Features<\/b> and selecting the <\/span>Shape map visual <\/b>checkbox as shown below (The order of options may vary depending on your <\/span>Power BI Desktop<\/b> version).<\/span><\/p>\n

\"M<\/p>\n

After restarting Power BI Desktop, select the <\/span>Shape Map <\/b>icon in the <\/span>Visualizations <\/b>pane as shown below.<\/span><\/p>\n

\"M<\/p>\n

Power BI Desktop<\/b> will create an empty <\/span>Shape Map<\/b>.<\/span><\/p>\n

\"M<\/p>\n

Prepare some data tables in advance to create a report. Normally, for easy viewing, we should use no more than 2 levels of administrative units in a report. For example, prepare data for regions – provinces\/cities (centrally run cities), or data for districts in a city, or data for wards\/communes in a district. A map with too many objects such as the following image would be difficult to understand.<\/span><\/p>\n

\"M<\/p>\n

After adding a <\/span>Shape Map<\/b> to your report, add the administrative division data from the previously prepared data table to the <\/span>Location <\/b>and <\/span>Color saturation<\/b> boxes. Once completed, select the <\/span>Format for visual<\/b> tab (paint brush icon) in the <\/span>Visualizations <\/b>pane, expand the <\/span>Map settings<\/b> section, select <\/span>Custom map<\/b> for <\/span>Map type, <\/b>and select <\/span>+ Add a map type<\/b>.<\/span><\/p>\n

\"M<\/p>\n

You can then click View map type key to see the names of data columns used to display the details of administrative divisions.<\/span><\/p>\n

\"M<\/p>\n

If you use the original map downloaded from <\/span>https:\/\/gadm.org\/download_country.html<\/span><\/a>, the naming convention is as follows: use Vietnamese place name with accent marks for NAME, Vietnamese place name without accent marks for VARNAME, _0 for national level, _1 for province\/centrally run city level, _2 for urban district\/district level, and _3 for commune level. The administrative division columns in your reporting data table should be prepared according to this convention to ensure accurate display on the report. The data on <\/span>Map keys<\/b> above were used for the example in Figure 2 at the beginning of this article. <\/span>Custom map <\/b>of <\/span>Shape Map <\/b>can be used when maps are in <\/span>TopoJSON <\/b>format. In case your map is in a different format, you can use online tools such as <\/span>Map Shaper <\/b>to convert it to <\/span>TopoJSON <\/b>format.\u00a0<\/span><\/p>\n

3. Search for available Vietnam maps<\/strong><\/h2>\n

The author’s usual source for maps is <\/span>https:\/\/gadm.org\/download_country.html<\/span><\/a><\/p>\n

\"M<\/p>\n

Vietnam maps from GADM offer all shape map data of national, provincial, district, and commune levels. However, Hoang Sa and Truong Sa are not included in the main map of Vietnam. Although displaying these two archipelagos has little meaning to a report, if you need them to be displayed for other reasons, you can search and download their maps using the keywords Paracel Islands (Hoang Sa) and Spratly Islands (Truong Sa). After downloading, we will have 3 files as follows:<\/span><\/p>\n

    \n
  1. gadm36_VNM_shp.zip (Vietnam administrative map)<\/span><\/li>\n
  2. gadm36_XPI_shp.zip (Hoang Sa map)<\/span><\/li>\n
  3. gadm36_XSP_shp.zip (Truong Sa map)<\/span><\/li>\n<\/ol>\n

    You can also obtain maps from <\/span>https:\/\/data.opendevelopmentmekong.net\/dataset\/a-phn-tnh?trk=article-ssr-frontend-pulse_little-text-block<\/span><\/a><\/p>\n

    \"M<\/p>\n

    The map on this page only shows provincial administrative divisions. However, it includes Hoang Sa and Truong Sa archipelagos (adjusted for better visibility though not accurate in terms of scale).<\/span><\/p>\n

    \"M<\/p>\n

    Depending on your purposes, you can use one of the two map sources above or find other sources.<\/span><\/p>\n

    4. Use Map Shaper<\/a>\u00a0to filter and select maps<\/strong><\/h2>\n

    Open the web application, drag and drop the map downloaded from the previous step to the application screen.<\/span><\/p>\n

    \"M<\/p>\n

    Mapshaper can work with the following data types: Shapefile, GeoJSON, TopoJSON, KLM, and CVS. Here, a shapefile file downloaded from GADM version 4.1 is used. (You can also drag and drop files in the extracted folder, or even drag and drop a whole zip file, into the Mapshaper application screen.)<\/span><\/p>\n

    \"Hu<\/p>\n

    \"M<\/p>\n

    Basemap<\/b> can be used to display map background images or satellite images. The <\/span>Layers <\/b>dialog box in the image below indicates that the second layer (including 710 polygons) is being displayed.<\/span><\/p>\n

    \"M<\/p>\n

    The image above also clearly shows that layer 0 includes 1 polygon which is the map of the entire country of Vietnam, layer 1 includes 63 polygons corresponding to 63 provinces\/cities, layer 2 includes 710 polygons corresponding to 710 urban districts\/districts, and layer 3 includes 11,163 polygons corresponding to the number of administrative divisions of ward\/commune level.\u00a0<\/span><\/p>\n

    If you need a map of 63 provinces, simply Export layer 1 to <\/span>TopoJSON<\/b>. Click the <\/span>Export <\/b>button in the upper right corner of the application screen, and set some options. Your desired map will be exported.<\/span><\/p>\n

    \"M<\/p>\n

    If you need to select a range, such as districts in Da Nang city, perform the following steps:<\/span><\/p>\n

      \n
    • Open the <\/span>Layers <\/b>dialog box. On the dialog, click\u00a0 on the eye icons to the right of the layers. Single click the icon to turn the layer’s display status on\/off and double click it to select the layer as the working layer so that your dialog is as shown below. There are 3 following states of the eye icon, the black icon indicating the working layer (you can view details, keep or delete objects of the layer), the blue ones indicating the displayed layers (view only), and the blurred ones indicating hidden layers. The goal of this step is to work with layer 2.<\/span><\/li>\n<\/ul>\n

      \"M<\/p>\n

        \n
      • Drag and zoom the map to the Da Nang area, press the arrow icon on the right side of the application screen and select <\/span>inspect features <\/b>(with a small triangle to the right). When you hover over an object (urban district\/district), detailed information will be displayed in the upper left corner of the screen.<\/span><\/li>\n<\/ul>\n

        \"M<\/p>\n

          \n
        • When you select <\/span>selection tool <\/b>(with a small triangle to the right), the detailed description of the object is displayed similarly when selecting <\/span>inspect features<\/b>.\u00a0<\/span><\/li>\n<\/ul>\n

          \"M<\/p>\n

            \n
          • Click to select each object (urban districts and districts) in Da Nang and then click the <\/span>Keep <\/b>button.<\/span><\/li>\n<\/ul>\n

            \"M<\/p>\n

              \n
            • All objects in layer 2 will be deleted except for the ones you have selected. Repeat the <\/span>Export <\/b>step for layer 2, you will now have a TopoJSON file of districts of Da Nang.<\/span><\/li>\n<\/ul>\n

              Use <\/span>Delete <\/b>command to delete the currently selected objects. Use <\/span>Duplicate <\/b>command to copy selected objects to a new layer (working layer). Use <\/span>Split <\/b>command to cut selected objects to a new layer (working layer). Use <\/span>Bounds <\/b>command to display the coordinates for the boundary area of the selected object group. Use <\/span>Edit data <\/b>command to edit detailed information of objects (in the dialog box at the top left of the application screen). Use <\/span>Clear <\/b>command to close the working menu for the selected objects.<\/span><\/p>\n

              After selecting the layer (working layer), you can also select <\/span>Simplify <\/b>to adjust the level of map detail (by sliding the slider). This command will remove some corner points of the displayed polygons, making the image smoother (similar to <\/span>Zoom Out<\/b>). Sometimes this function might cause some small islands to be invisible. The more you simplify the map, the smaller the TopoJSON file will be. Depending on your purpose, you should try different detail level of the map to simplify your map and reduce the file size. (In some cases, you may hardly notice any difference even when reducing the map detail level by 50%.)\u00a0<\/span><\/p>\n

              In conclusion, this overview highlights the author’s practical insights and the benefits of using <\/span>Shape Maps<\/b> for <\/span>Power BI Desktop<\/b>. <\/span>Shape Maps<\/b> enhance the clarity and user-friendliness of reports when comparing statistical analysis data across regions. If you want to use shape maps for objects other than administrative divisions, you can use map editor software to draw and export a map to TopoJSON format.<\/span><\/p>\n\n\n\n
              Exclusive article by FPT IS Expert<\/strong><\/p>\n

              Author Pham Quang Son \u2013 Consulting expert, Government sector, FPT IS<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"author":3,"featured_media":16474,"parent":0,"template":"","nang_luc":[828,790],"danh_muc_goc_nhin_so":[528,789],"dich_vu":[858,859],"linh_vuc":[856,519],"platform":[],"san_pham":[],"the_goc_nhin_so":[],"class_list":["post-16473","goc_nhin_so","type-goc_nhin_so","status-publish","has-post-thumbnail","hentry","nang_luc-digital-transformation","nang_luc-experts-sharing","danh_muc_goc_nhin_so-digital-transformation","danh_muc_goc_nhin_so-expert-sharing","dich_vu-private-sector-news","dich_vu-public-sector-news","linh_vuc-enterprises","linh_vuc-government"],"acf":[],"_links":{"self":[{"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/goc_nhin_so\/16473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/goc_nhin_so"}],"about":[{"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/types\/goc_nhin_so"}],"author":[{"embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/users\/3"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/media\/16474"}],"wp:attachment":[{"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/media?parent=16473"}],"wp:term":[{"taxonomy":"nang_luc","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/nang_luc?post=16473"},{"taxonomy":"danh_muc_goc_nhin_so","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/danh_muc_goc_nhin_so?post=16473"},{"taxonomy":"dich_vu","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/dich_vu?post=16473"},{"taxonomy":"linh_vuc","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/linh_vuc?post=16473"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/platform?post=16473"},{"taxonomy":"san_pham","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/san_pham?post=16473"},{"taxonomy":"the_goc_nhin_so","embeddable":true,"href":"https:\/\/fpt-is.com\/en\/wp-json\/wp\/v2\/the_goc_nhin_so?post=16473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}