Power BI Maps – Shape Map in Power BI Desktop

FREE Online Courses: Click, Learn, Succeed, Start Now!

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

Technology is evolving rapidly!
Stay updated with DataFlair on WhatsApp!!

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

idabbrisonamepostal
au-waWAAU-WAWestern AustraliaWA
au-vicVicAU-VICVictoriaVIC
au-tasTasAU-TASTasmaniaTAS
au-saSAAU-SASouth AustraliaSA
au-qldQldAU-QLDQueenslandQLD
au-ntNTAU-NTNorthern TerritoryNT
au-nswNSWAU-NSWNew South WalesNSW
au-actACTAU-ACTAustralian Capital TerritoryACT

Let’s discuss Power BI Custom Visualization
Austria: States

idisonamename-enpostal
at-wiAT-9WienViennaWI
at-voAT-8VorarlbergVorarlbergVO
at-trAT-7TirolTyrolTR
at-stAT-6SteiermarkStyriaST
at-szAT-5SalzburgSalzburgSZ
at-ooAT-4OberösterreichUpper AustriaOO
at-noAT-3NiederösterreichLower AustriaNO
at-kaAT-2KärntenCarinthiaKA
at-buAT-1BurgenlandBurgenlandBU

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

idisonamepostal
ca-nuCA-NUNunavutNU
ca-ntCA-NTNorthwest TerritoriesNT
ca-ytCA-YTYukonYT
ca-skCA-SKSaskatchewanSK
ca-qcCA-QCQuebecQC
ca-peCA-PEPrince Edward IslandPE
ca-onCA-ONOntarioON
ca-nsCA-NSNova ScotiaNS
ca-nlCA-NLNewfoundland and LabradorNL
ca-nbCA-NBNew BrunswickNB
ca-mbCA-MBManitobaMB
ca-bcCA-BCBritish ColumbiaBC
ca-abCA-ABAlbertaAB

France: Regions

idnamename-en
AlsaceAlsaceAlsace
Rhone-AlpesRhône-AlpesRhone-Alpes
Provence-Alpes-Cote d’AzurProvence-Alpes-Côte d’AzurProvence-Alpes-Cote d’Azur
Poitou-CharentesPoitou-CharentesPoitou-Charentes
PicardiePicardiePicardy
Pays de la LoirePays de la LoirePays de la Loire
Nord-Pas-de-CalaisNord-Pas-de-CalaisNord-Pas-de-Calais
Midi-PyreneesMidi-PyrénéesMidi-Pyrenees
LorraineLorraineLorraine
LimousinLimousinLimousin
Languedoc-RoussillonLanguedoc-RoussillonLanguedoc-Roussillon
Ile-del-FranceÎle-de-FranceIle-de-France
Haute-NormandieHaute-NormandieUpper Normandy
Franche-ComteFranche-ComtéFranche-Comte
CorseCorseCorsica
Champagne-ArdenneChampagne-ArdenneChampagne-Ardenne
Centre-Val de LoireCentre-Val de LoireCentre-Val de Loire
BretagneBretagneBrittany
BourgogneBourgogneBurgundy
Basse-NormandieBasse-NormandieLower Normandy
AuvergneAuvergneAuvergne
AquitaineAquitaineAquitaine

Germany: States

idisonamename-enpostal
de-beDE-BEBerlinBerlinBE
de-thDE-THThüringenThuringiaTH
de-stDE-STSachsen-AnhaltSaxony-AnhaltST
de-snDE-SNSachsenSaxonySN
de-mvDE-MVMecklenburg-VorpommernMecklenburg-VorpommernMV
de-bbDE-BBBrandenburgBrandenburgBB
de-shDE-SHSchleswig-HolsteinSchleswig-HolsteinSH
de-slDE-SLSaarlandSaarlandSL
de-rpDE-RPRheinland-PfalzRhineland-PalatinateRP
de-nwDE-NWNordrhein-WestfalenNorth Rhine-WestphaliaNW
de-niDE-NINiedersachsenLower SaxonyNI
de-heDE-HEHessenHesseHE
de-hhDE-HHHamburgHamburgHH
de-hbDE-HBBremenBremenHB
de-byDE-BYBayernBavariaBY
de-bwDE-BWBaden-WürttembergBaden-WurttembergBW

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

idisonamename-enpostal
it-vnIT-34VenetoVenetoVN
it-vdIT-23Valle d’AostaAosta ValleyVD
it-umIT-55UmbriaUmbriaUM
it-ttIT-32Trentino-Alto AdigeTrentino-South TyrolTT
it-tcIT-52ToscanaTuscanyTC
it-scIT-82SiciliaSicilySC
it-sdIT-88SardegnaSardiniaSD
it-pmIT-21PiemontePiedmontPM
it-mlIT-67MoliseMoliseML
it-mhIT-57MarcheMarcheMH
it-lmIT-25LombardiaLombardyLM
it-lgIT-42LiguriaLiguriaLG
it-lzIT-62LazioLazioLZ
it-fvIT-36Friuli-Venezia GiuliaFriuli-Venezia GiuliaFV
it-erIT-45Emilia-RomagnaEmilia-RomagnaER
it-cmIT-72CampaniaCampaniaCM
it-lbIT-78CalabriaCalabriaLB
it-bcIT-77BasilicataBasilicataBC
it-puIT-75ApuliaPugliaPU
it-abIT-65AbruzzoAbruzzoAB

Mexico: States

idabreviaturaisonamename-enpostal
mx-zacZac.MX-ZACZacatecasZacatecasZA
mx-yucYuc.MX-YUCYucatánYucatanYU
mx-verVer.MX-VERVeracruzVeracruzVE
mx-tlaTlax.MX-TLATlaxcalaTlaxcalaTL
mx-tamTamps.MX-TAMTamaulipasTamaulipasTM
mx-tabTab.MX-TABTabascoTabascoTB
mx-sonSon.MX-SONSonoraSonoraSO
mx-sinSin.MX-SINSinaloaSinaloaSI
mx-slpS.L.P.MX-SLPSan Luis PotosíSan Luis PotosiSL
mx-rooQ.R.MX-ROOQuintana RooQuintana RooQR
mx-queQro.MX-QUEQuerétaroQueretaroQE
mx-puePue.MX-PUEPueblaPueblaPU
mx-oaxOax.MX-OAXOaxacaOaxacaOA
mx-nleN.L.MX-NLENuevo LeónNuevo LeonNL
mx-nayNay.MX-NAYNayaritNayaritNA
mx-morMor.MX-MORMorelosMorelosMR
mx-micMich.MX-MICMichoacánMichoacanMC
mx-mexMéx.MX-MEXEstado de MéxicoMexico StateMX
mx-jalJal.MX-JALJaliscoJaliscoJA
mx-hidHgo.MX-HIDHidalgoHidalgoHI
mx-groGro.MX-GROGuerreroGuerreroGR
mx-guaGto.MX-GUAGuanajuatoGuanajuatoGT
mx-durDgo.MX-DURDurangoDurangoDU
mx-difCol.MX-DIFCiudad de MéxicoMexico CityDF
mx-colCoah.MX-COLColimaColimaCL
mx-coaChis.MX-COACoahuilaCoahuilaCA
mx-chhChih.MX-CHHChihuahuaChihuahuaCH
mx-chpCDMX.MX-CHPChiapasChiapasCP
mx-camCamp.MX-CAMCampecheCampecheCM
mx-bcsB.C.S.MX-BCSBaja California SurBaja California SurBS
mx-bcnB.C.MX-BCNBaja CaliforniaBaja CaliforniaBN
mx-aguAgs.MX-AGUAguascalientesAguascalientesAG

Netherlands: Provinces

idisonamename-en
nl-zhNL-ZHZuid-HollandSouth Holland
nl-zeNL-ZEZeelandZeeland
nl-utNL-UTUtrechtUtrecht
nl-ovNL-OVOverijsselOverijssel
nl-nhNL-NHNoord-HollandNorth Holland
nl-nbNL-NBNoord-BrabantNorth Brabant
nl-liNL-LILimburgLimburg
nl-grNL-GRGroningenGroningen
nl-geNL-GEGelderlandGelderland
nl-frNL-FRFryslânFriesland
nl-flNL-FLFlevolandFlevoland
nl-drNL-DRDrentheDrenthe

UK: Countries

idisoname
gb-wlsGB-WLSWales
gb-sctGB-SCTScotland
gb-nirGB-NIRNorthern Ireland
gb-engGB-ENGEngland

USA: States

idnamepostal
us-miMichiganMI
us-akAlaskaAK
us-hiHawaiiHI
us-flFloridaFL
us-laLouisianaLA
us-arArkansasAR
us-scSouth CarolinaSC
us-gaGeorgiaGA
us-msMississippiMS
us-alAlabamaAL
us-nmNew MexicoNM
us-txTexasTX
us-tnTennesseeTN
us-ncNorth CarolinaNC
us-okOklahomaOK
us-azArizonaAZ
us-moMissouriMO
us-vaVirginiaVA
us-ksKansasKS
us-kyKentuckyKY
us-coColoradoCO
us-mdMarylandMD
us-wvWest VirginiaWV
us-deDelawareDE
us-dcDistrict of ColumbiaDC
us-ilIllinoisIL
us-ohOhioOH
us-caCaliforniaCA
us-utUtahUT
us-nvNevadaNV
us-inIndianaIN
us-njNew JerseyNJ
us-riRhode IslandRI
us-ctConnecticutCT
us-paPennsylvaniaPA
us-nyNew YorkNY
us-neNebraskaNE
us-maMassachusettsMA
us-iaIowaIA
us-nhNew HampshireNH
us-orOregonOR
us-mnMinnesotaMN
us-vtVermontVT
us-idIdahoID
us-wiWisconsinWI
us-wyWyomingWY
us-sdSouth DakotaSD
us-ndNorth DakotaND
us-meMaineME
us-mtMontanaMT
us-waWashingtonWA

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

Did we exceed your expectations?
If Yes, share your valuable feedback on Google

follow dataflair on YouTube

2 Responses

  1. Lokeshkumar G says:

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

  2. Sunil Reddy says:

    Good morning power Bi team. I want to Add the India Map in power Bi. How to add I m trying to Add map but is shows only few country maps How to add India map in shape map tool. Please give me the suggestion.

Leave a Reply

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