Simple way of creating Shape map visual in Power BI

Shape Files are nothing but for storing Geographic information data. It is in vector data format. Geographic features in shape file can be represented by points, lines, or polygons(areas).? All shape files extensions may differ, but name remains same. It usually consists of six files.?There are 3 minimum files which are dbf, shx, shp. Here dbf file is database file to store attributes. We cannot directly import shape file in Power bi Desktop.?We need Topojson format, or we need to convert to csv file before importing to Power BI. To converting to Topojson file, we have many tools like Mapshaper. In mapshaper, we can convert projections. When we want to export to csv, we need to open dbf file in Microsoft Excel and save file in csv format. Then we can import to Power BI Desktop.?

To use csv format, we should have longitude and latitude, or any region attributes should present. As shape map is a preview feature, first we need to go to options and settings, go to preview and select shape map visual. And we need to restart session to apply. We can select shape map visual in canvas, after that we can select attributes. In format we can select shape of map for any particular country. If we want customised map, we need topojson file can be uploaded in custom map. By Selecting 3 dots we can edit map visual. This is the simple way of creating Shape map Visual in Power bI using Shape File.

Tobore Idowu (PMP)

2x Top Voice ??| Project Manager - Leadership Coach | Impact-Oriented Leader | Client management | Data Management | Analytics | Public Speaker | Training Facilitator | Teen Coach | Compere

1 å¹´

I am having trouble using a CSV file from grid3. I opened a dbf using Excel but I don't see any columns for longitude and latitude. What I see is "Shape__Area" and "Shape__Length". I tried to import this but still can't see the shape map in the visualization pane. Now I am trying to bring in a topojson file but I am not sure how to import that. A mini guide will be highly appreciated

赞
回复

要查看或添加评论,请登录

Harsha Veena的更多文章

  • EER Diagram in MySQL

    EER Diagram in MySQL

    EER(Enhanced entity-relationship) diagrams are basically a more expansive version of ER diagrams. EER models are…

  • IntCastingNaNError in Pandas

    IntCastingNaNError in Pandas

    This Error usually raised when attempting an astype operation on an array with NaN o an integer datatype. To deal with…

  • Dealing value error in python while converting object to float.

    Dealing value error in python while converting object to float.

    This is small article for converting object to float in process of data cleaning in python. Everyday Data analysts have…

社区洞察

其他会员也浏览了