Power-BI Postcode Maps
Power-BI Postcode Maps for Dashboards, KPI and Sales Reporting
Use the postcode maps of Maps4Office to colorize your sales territories for Power BI Dashboards. Create KPI and Sales Reporting with Visuals in Power BI Desktop.
Microsoft Power BI provides two types of visualization elements (so-called visuals) to display data and figures with geographic information systems on a Power BI map. On the one hand, there is the assignment element (visuals) and the area cartogram (shape map). The “Filled Map” option is interesting, if you want to set points or bubbles on a map. The Visual Shape Map fills the postcode areas or administration maps. So, for this visual you can create heat maps.
PowerBI Visual: Shape Map vs. Filled Map
Example: Sales Territories AT (Austria with four digit ZIP-Code Map)
Example: Administration, Sales Map in Germany incl. State of Bavaria
Swiss Postcode Map for PowerBI Desktop with 4-digits
For both Power BI Visual maps Microsoft uses the geocoding of Bing Maps. Usually, location, latitude and longitude as well as geographic fields are transferred to Bing to color the elements or display points.
Before you select this element, please check in your Power BI settings if the option “shape map visual” is activated. In Power BI, click File -> Options and Settings -> Options off. Under Preview Features, the check mark must be set to work with the element. There may be a “restart” of Power BI to follow – so please save the current dashboard.
Settings Power BI: Shape map Visual
Coloring Power-BI Maps with postal code areas
To visualize postcodes on a Power BI map or to color the postcode areas, we use the “shape map” Visual element. Here the postcode maps can be imported directly into Power BI as individual postcode maps in TopoJSON format.
Depending on how your table or query is structured, the postcode numbers should always be defined as text elements and not as numbers, since many regions have 01xxx postcode numbers. At the same time, Power BI would want to sum up postcode numbers that are defined as a number, which does not lead to colouring.
Power BI’s filter function allows you to select postcode numbers directly or in a range to view the result. Power BI automatically zooms into these postcode regions.
To create a postcode heatmap map, you can use e.g. sales figures or sales ratios (numerical values) and drag the field to “color saturation”. The field “Postal Code” is then selected as the location.
Also pay attention to the postcode numbers of large recipient groups. For example, the German Bundestag (postal code 11010), WDR (postal code 50600), Frankfurt Trade Fair Tower have their own postal code numbers and cannot be coloured on an area cartogram in Power BI. Only the visual “shape map” helps here. For this visual, however, you need the geographical data of longitude and latitude and you may have to perform a manual geocoding here.
Postcode maps can contain different levels. For example, two-digit postcode maps should rather be used for sales and marketing. For controllers, the five-digit (Germany) or four-digit postcode areas (Austria, Switzerland) are more interesting. The finer the map is, the more processing power is required by Power BI and the slower the zoom behaviour in the map. The same applies to political maps, i.e. federal states, counties, municipal maps.
Latitude and longitude into the Map
If you only want to use points or bubble charts in your Power BI Dashboard, it is sufficient to specify longitude and latitude in the data fields. Additional information about city or country names does not need to be provided. The data type must be a number format with at least 2 decimal places. We ourselves use at least 6 decimal places for our maps to encode streets, postcode numbers or house numbers.
Business Intelligent Projects for your company
Our Business Intelligence solutions and BI projects are designed to structure information and thus make dashboards, management reports reliable and innovative. Our focus is on consulting, development and help you to use MS PowerBI for your business.
We help you to connect heterogeneous data structures and validate them, create ETL processes and SQL queries (e.g. MSSQL, ORACLE, Excel, Access, JSON, XML etc.).
Our team, stallwanger IT.dev, helps you to create JavaSkripts, D3 scripts or SVG und BI-Maps for your Management Reporting.
Our expertise in accounting, financial controlling, personal reporting (HR-KPIs) or in the RE environment can provide you with additional impulses at eye level.