Power BI Maps – Shape Map in Power BI Desktop

Keeping you updated with latest technology trends, Join DataFlair on Telegram

1. Objective

In our last session, we studied Power BI Building Blocks. Today, in this Power BI Maps Tutorial, we will learn how to create Shape Map in Power BI Desktop. Moreover, we will discuss how to utilize, test custom map and review conduct and prerequisites. Along with this, we will cover its area keys.
So, let’s create a Shape Map in Power BI Desktop.

Power BI Maps - Shape Map in Power BI Desktop

Power BI Maps – Shape Map in Power BI Desktop

2. Shape Map in Power BI Desktop

In Power BI Desktop, you make a Shape Map in Power BI visual to demonstrate relative examinations of districts on a guide by applying distinctive hues to various areas. As opposed to the Map visual, Shape Map in Power BI Desktop can’t demonstrate exact topographical areas of information focuses on a guide; rather, its primary reason for existing is to indicate relative correlations of locales on a guide by shading them in an unexpected way.
Power BI Shape Map visuals depend on ESRI/TopoJSON maps which have the convincing capacity to utilize Power BI custom maps that you can make. For example, topographical, seating courses of action, floor designs, and others. The capacity to utilize custom maps in Power BI isn’t accessible in this Preview arrival of Shape Map.
Do you know How to Create Hyperlink in Power BI in Dashboard & Excel Power Pivot

3. How to Create Shape Map in Power BI?

You can test the Shape Map in Power BI control with the maps that are shipping with this preview discharge, or you can utilize your own custom guide as long as it meets the necessities delineated in the accompanying area called Use Custom Maps.
The Shape Map in Power BI visual is in preview and should empower. To empower Shape Map in Power BI, select File > Options and Settings > Options > Preview Features, at that point select the Shape Map Visual checkbox. You’ll have to restart Power BI Desktop after you make the choice.

Shape Map in Power BI Desktop

Step.1 – To Create Shape Map in Power BI Desktop

When the Power BI Shape Map is empowered, tap the Shape Map control from the Visualizations sheet.

Shape Map in Power BI Desktop

Step.2 – To Create Shape Map in Power BI

Power BI Desktop makes a vacant Shape Map visual plan canvas.
Let’s read about How to Create Power BI Ribbon Chart?

Shape Map in Power BI Desktop

Step.2 – To Create Shape Map in Power BI

Find a way to make a Shape Map in Power BI Desktop:

  1. In the Fields sheet, drag an information field that has the area names (or shortenings) onto the Location can, and an information measure field into the Color immersion pail (you won’t see a guide yet).

Note – See the segment titled Getting Map Data, underneath, for data on the best way to rapidly get the outline to test Shape Map.

Shape Map in Power BI Desktop

Shape Map in Power BI Desktop

  1. In the Format settings sheet, extend Shape, and select from the Standard Maps drop-down to demonstrate your information. Now the rendering shows up, as appeared in the accompanying picture.
Shape Map in Power BI Desktop

Step.2 – To Create Shape Map in Power BI Desktop

Note – In the Region Keys segment toward the finish of this article is a gathering of tables that have to delineate keys you can use to test the Shape Map in Power BI Desktop.
Follow this link to know How to Create Power BI Donut Chart

  1. You would then be able to alter the guide projection and zooming settings, and additionally, the shades of information focus, from the Format settings sheet. You can likewise adjust zoom settings. For instance, you can change hues, set maximums and essentials, et cetera.
Shape Map in Power BI Desktop

Step.3 – To Create Shape Map in Power BI Desktop

You can likewise add a classification information segment to the Legend basin, and characterize the guide locales in light of classifications.

4. How to Utilize Custom Maps?

You can utilize custom maps with Shape Map in Power BI, as long as they are in the TopoJSON arrange. On the off chance that your guide is in another organization, you can utilize online devices. For example, Map Shaper to change over your shapefiles or your GeoJSON maps into the TopoJSON arrange.
To utilize your TopoJSON delineate, add a Shape Map in Power BI Desktop to your report and add a few information to the Location and Color immersion basins. At that point, in the Visualizations sheet with the Format segment chose (appeared as (1) in the accompanying picture), grow the Shape segment and select + Add Map.

Shape Map in Power BI Desktop

Shape Map in Power BI – Utilize Custom Maps

Refer this link – Power BI Conditional Formatting

5. Test Custom Map

The Offices of the United States Attorneys discharges a yearly financial write about their case and caseload information. The majority of their reports can be found in the connection beneath,
Since states can be separated into different areas, we need to utilize a custom shape delineate. By bringing in the TopoJSON guide of the U.S. legal locale into Power BI Desktop, we would then be able to envision the yearly financial head prosecutor information. The picture beneath demonstrates a case of this guide.

Shape Map in Power BI Desktop

Shape Map in Power BI Desktop – Test Custom Map

You can do fascinating things with the individual state maps too, and indicate more detail in view of the regions it contains.

Shape Map in Power BI Desktop

Shape Map in Power BI Desktop – Test Custom Map

In the event that you’d get a kick out of the chance to try different things with this dataset and perception, you can download the first PBIX document that was utilized to produce this report utilizing the accompanying connection.
Custom shape delineate.PBIX record
Do you know how many Types of Filters are in Power BI

6. Getting Map Information

To rapidly get information into a model so you can test Shape Map in Power BI Desktop, you can duplicate one of the tables toward the finish of this article, at that point select Enter Data from the Home lace.

Shape Map in Power BI Desktop

Shape Map in Power BI Desktop –  Getting Power Map Information

On the off chance that your information has different segments, you should utilize an editorial manager like Excel to glue the information, at that point duplicate every datum segment independently. You would then be able to glue the information into Power BI Desktop. The best line is naturally recognized as a header.
You can enter another section essentially by writing another segment name (in the clear segment to one side), at that point include values in every cell, much the same as you can do in Excel. Whenever completed, select Load and the table is added to the information demonstrate for Power BI Desktop.
Note – When working with nations or districts, utilize the three-letter shortened form to guarantee that geocoding works appropriately in outline. Try not to utilize two-letter contractions, as a few nations or districts may not be legitimately perceived.
Have a look at Power BI Mobile Apps – How to Install Power BI Apps
On the off chance that you just have two-letter shortened forms, look at this outer blog entry for ventures on the most proficient method to relate your two-letter nation/district contractions with three-letter nation/locale shortenings.

7. Review Conduct and Prerequisites

There are a couple of contemplations and prerequisites for this Preview arrival of Shape Map in Power BI Desktop:

  • The Shape Map visual is in Preview and should be empowered in Power BI Desktop. To empower Shape Map in Power BI, select File > Options and Settings > Options > Preview Features, at that point select the Shape Map Visual checkbox.
  • Presently, you should likewise have the Color immersion basin set all together for the Legend characterization to work appropriately.
  • The last discharge form of Shape Map will have a UI that demonstrates the guide keys of the right now chosen delineate. In this Preview discharge, you can reference the guide area enters in the tables found in the accompanying Region Keys segment of this article.
  • The Shape Map in Power BI Desktop will plot up to a most extreme of 1,000 information focuses.

8. Area Keys

Utilize the accompanying Region Keys in this Preview discharge to test Shape Map in Power BI.
Australia: States

id abbr iso name postal
au-wa WA AU-WA Western Australia WA
au-vic Vic AU-VIC Victoria VIC
au-tas Tas AU-TAS Tasmania TAS
au-sa SA AU-SA South Australia SA
au-qld Qld AU-QLD Queensland QLD
au-nt NT AU-NT Northern Territory NT
au-nsw NSW AU-NSW New South Wales NSW
au-act ACT AU-ACT Australian Capital Territory ACT

Let’s discuss Power BI Custom Visualization
Austria: States

id iso name name-en postal
at-wi AT-9 Wien Vienna WI
at-vo AT-8 Vorarlberg Vorarlberg VO
at-tr AT-7 Tirol Tyrol TR
at-st AT-6 Steiermark Styria ST
at-sz AT-5 Salzburg Salzburg SZ
at-oo AT-4 Oberösterreich Upper Austria OO
at-no AT-3 Niederösterreich Lower Austria NO
at-ka AT-2 Kärnten Carinthia KA
at-bu AT-1 Burgenland Burgenland BU

Brazil: States

id
Tocantins
Pernambuco
Goias
Sergipe
Sao Paulo
Santa Catarina
Roraima
Rondonia
Rio Grande do Sul
Rio Grande do Norte
Rio de Janeiro
Piaui
Parana
Paraiba
Para
Minas Gerais
Mato Grosso
Maranhao
Mato Grosso do Sul
Distrito Federal
Ceara
Espirito Santo
Bahia
Amazonas
Amapa
Alagoas
Acre
Litigated Zone 1
Litigated Zone 2
Litigated Zone 3
Litigated Zone 4

Read about Working of Power BI Gateway
Canada: Provinces

id iso name postal
ca-nu CA-NU Nunavut NU
ca-nt CA-NT Northwest Territories NT
ca-yt CA-YT Yukon YT
ca-sk CA-SK Saskatchewan SK
ca-qc CA-QC Quebec QC
ca-pe CA-PE Prince Edward Island PE
ca-on CA-ON Ontario ON
ca-ns CA-NS Nova Scotia NS
ca-nl CA-NL Newfoundland and Labrador NL
ca-nb CA-NB New Brunswick NB
ca-mb CA-MB Manitoba MB
ca-bc CA-BC British Columbia BC
ca-ab CA-AB Alberta AB

France: Regions

id name name-en
Alsace Alsace Alsace
Rhone-Alpes Rhône-Alpes Rhone-Alpes
Provence-Alpes-Cote d’Azur Provence-Alpes-Côte d’Azur Provence-Alpes-Cote d’Azur
Poitou-Charentes Poitou-Charentes Poitou-Charentes
Picardie Picardie Picardy
Pays de la Loire Pays de la Loire Pays de la Loire
Nord-Pas-de-Calais Nord-Pas-de-Calais Nord-Pas-de-Calais
Midi-Pyrenees Midi-Pyrénées Midi-Pyrenees
Lorraine Lorraine Lorraine
Limousin Limousin Limousin
Languedoc-Roussillon Languedoc-Roussillon Languedoc-Roussillon
Ile-del-France Île-de-France Ile-de-France
Haute-Normandie Haute-Normandie Upper Normandy
Franche-Comte Franche-Comté Franche-Comte
Corse Corse Corsica
Champagne-Ardenne Champagne-Ardenne Champagne-Ardenne
Centre-Val de Loire Centre-Val de Loire Centre-Val de Loire
Bretagne Bretagne Brittany
Bourgogne Bourgogne Burgundy
Basse-Normandie Basse-Normandie Lower Normandy
Auvergne Auvergne Auvergne
Aquitaine Aquitaine Aquitaine

Germany: States

id iso name name-en postal
de-be DE-BE Berlin Berlin BE
de-th DE-TH Thüringen Thuringia TH
de-st DE-ST Sachsen-Anhalt Saxony-Anhalt ST
de-sn DE-SN Sachsen Saxony SN
de-mv DE-MV Mecklenburg-Vorpommern Mecklenburg-Vorpommern MV
de-bb DE-BB Brandenburg Brandenburg BB
de-sh DE-SH Schleswig-Holstein Schleswig-Holstein SH
de-sl DE-SL Saarland Saarland SL
de-rp DE-RP Rheinland-Pfalz Rhineland-Palatinate RP
de-nw DE-NW Nordrhein-Westfalen North Rhine-Westphalia NW
de-ni DE-NI Niedersachsen Lower Saxony NI
de-he DE-HE Hessen Hesse HE
de-hh DE-HH Hamburg Hamburg HH
de-hb DE-HB Bremen Bremen HB
de-by DE-BY Bayern Bavaria BY
de-bw DE-BW Baden-Württemberg Baden-Wurttemberg BW

Ireland: Counties

id
Wicklow
Wexford
Westmeath
Waterford
Sligo
Tipperary
Roscommon
Offaly
Monaghan
Meath
Mayo
Louth
Longford
Limerick
Leitrim
Laoighis
Kilkenny
Kildare
Kerry
Galway
Dublin
Donegal
Cork
Clare
Cavan
Carlow

Do you know about How to Create Power BI Funnel Charts?
Italy: Regions

id iso name name-en postal
it-vn IT-34 Veneto Veneto VN
it-vd IT-23 Valle d’Aosta Aosta Valley VD
it-um IT-55 Umbria Umbria UM
it-tt IT-32 Trentino-Alto Adige Trentino-South Tyrol TT
it-tc IT-52 Toscana Tuscany TC
it-sc IT-82 Sicilia Sicily SC
it-sd IT-88 Sardegna Sardinia SD
it-pm IT-21 Piemonte Piedmont PM
it-ml IT-67 Molise Molise ML
it-mh IT-57 Marche Marche MH
it-lm IT-25 Lombardia Lombardy LM
it-lg IT-42 Liguria Liguria LG
it-lz IT-62 Lazio Lazio LZ
it-fv IT-36 Friuli-Venezia Giulia Friuli-Venezia Giulia FV
it-er IT-45 Emilia-Romagna Emilia-Romagna ER
it-cm IT-72 Campania Campania CM
it-lb IT-78 Calabria Calabria LB
it-bc IT-77 Basilicata Basilicata BC
it-pu IT-75 Apulia Puglia PU
it-ab IT-65 Abruzzo Abruzzo AB

Mexico: States

id abreviatura iso name name-en postal
mx-zac Zac. MX-ZAC Zacatecas Zacatecas ZA
mx-yuc Yuc. MX-YUC Yucatán Yucatan YU
mx-ver Ver. MX-VER Veracruz Veracruz VE
mx-tla Tlax. MX-TLA Tlaxcala Tlaxcala TL
mx-tam Tamps. MX-TAM Tamaulipas Tamaulipas TM
mx-tab Tab. MX-TAB Tabasco Tabasco TB
mx-son Son. MX-SON Sonora Sonora SO
mx-sin Sin. MX-SIN Sinaloa Sinaloa SI
mx-slp S.L.P. MX-SLP San Luis Potosí San Luis Potosi SL
mx-roo Q.R. MX-ROO Quintana Roo Quintana Roo QR
mx-que Qro. MX-QUE Querétaro Queretaro QE
mx-pue Pue. MX-PUE Puebla Puebla PU
mx-oax Oax. MX-OAX Oaxaca Oaxaca OA
mx-nle N.L. MX-NLE Nuevo León Nuevo Leon NL
mx-nay Nay. MX-NAY Nayarit Nayarit NA
mx-mor Mor. MX-MOR Morelos Morelos MR
mx-mic Mich. MX-MIC Michoacán Michoacan MC
mx-mex Méx. MX-MEX Estado de México Mexico State MX
mx-jal Jal. MX-JAL Jalisco Jalisco JA
mx-hid Hgo. MX-HID Hidalgo Hidalgo HI
mx-gro Gro. MX-GRO Guerrero Guerrero GR
mx-gua Gto. MX-GUA Guanajuato Guanajuato GT
mx-dur Dgo. MX-DUR Durango Durango DU
mx-dif Col. MX-DIF Ciudad de México Mexico City DF
mx-col Coah. MX-COL Colima Colima CL
mx-coa Chis. MX-COA Coahuila Coahuila CA
mx-chh Chih. MX-CHH Chihuahua Chihuahua CH
mx-chp CDMX. MX-CHP Chiapas Chiapas CP
mx-cam Camp. MX-CAM Campeche Campeche CM
mx-bcs B.C.S. MX-BCS Baja California Sur Baja California Sur BS
mx-bcn B.C. MX-BCN Baja California Baja California BN
mx-agu Ags. MX-AGU Aguascalientes Aguascalientes AG

Netherlands: Provinces

id iso name name-en
nl-zh NL-ZH Zuid-Holland South Holland
nl-ze NL-ZE Zeeland Zeeland
nl-ut NL-UT Utrecht Utrecht
nl-ov NL-OV Overijssel Overijssel
nl-nh NL-NH Noord-Holland North Holland
nl-nb NL-NB Noord-Brabant North Brabant
nl-li NL-LI Limburg Limburg
nl-gr NL-GR Groningen Groningen
nl-ge NL-GE Gelderland Gelderland
nl-fr NL-FR Fryslân Friesland
nl-fl NL-FL Flevoland Flevoland
nl-dr NL-DR Drenthe Drenthe

UK: Countries

id iso name
gb-wls GB-WLS Wales
gb-sct GB-SCT Scotland
gb-nir GB-NIR Northern Ireland
gb-eng GB-ENG England

USA: States

id name postal
us-mi Michigan MI
us-ak Alaska AK
us-hi Hawaii HI
us-fl Florida FL
us-la Louisiana LA
us-ar Arkansas AR
us-sc South Carolina SC
us-ga Georgia GA
us-ms Mississippi MS
us-al Alabama AL
us-nm New Mexico NM
us-tx Texas TX
us-tn Tennessee TN
us-nc North Carolina NC
us-ok Oklahoma OK
us-az Arizona AZ
us-mo Missouri MO
us-va Virginia VA
us-ks Kansas KS
us-ky Kentucky KY
us-co Colorado CO
us-md Maryland MD
us-wv West Virginia WV
us-de Delaware DE
us-dc District of Columbia DC
us-il Illinois IL
us-oh Ohio OH
us-ca California CA
us-ut Utah UT
us-nv Nevada NV
us-in Indiana IN
us-nj New Jersey NJ
us-ri Rhode Island RI
us-ct Connecticut CT
us-pa Pennsylvania PA
us-ny New York NY
us-ne Nebraska NE
us-ma Massachusetts MA
us-ia Iowa IA
us-nh New Hampshire NH
us-or Oregon OR
us-mn Minnesota MN
us-vt Vermont VT
us-id Idaho ID
us-wi Wisconsin WI
us-wy Wyoming WY
us-sd South Dakota SD
us-nd North Dakota ND
us-me Maine ME
us-mt Montana MT
us-wa Washington WA

So, this was all about Shape Map in Power BI. Hope you like our explanation.

9. Conclusion

Hence, in this tutorial, we learned about the Shape Map in Power BI. In addition, we discussed how to utilize, test custom map and review conduct and prerequisites. Along with this, we covered the area keys. Still, you have a query, feel free to ask in the comment box.
Related Topic – Power BI and Excel Integration 
For reference

1 Response

  1. Lokeshkumar G says:

    How to create custom territory shape files (boundary/polygon level) with the postalcode?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.