Simple way of creating Shape map visual in Power BI
Harsha Veena
Data Analyst | PL 300 | PL 900 | Microsoft Power Apps Developer , Power Automate, SQL, Python, Machine Learning, PySpark, Power BI | AI
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.
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