FREE Online Courses: Dive into Knowledge for Free. Learn More!
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
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.
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.
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?
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:
- 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
- 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.
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
- 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.
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 – 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 – 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 – 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 – 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