Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Problem in choropleth map of the municipalities - brazil

 

I encountered the following problems when creating a choropleth map of the municipalities in the state of Paraíba, Brazil.


The fields with the name of the municipality were categorized as: LOCAL

I already used the MUNICIPALITY or CITY categories but the mapping didn't work.


Municipality of Quixabá -
ibge_geographical code: 2512606
The mapping points to a village in the municipality of Remígio (2512705).

 

Municipality of Santa Terezinha -
cod_geografico ibge: 2513802
The mapping points to a neighborhood in the municipality of Guarabira (2506301).

Status: Investigating

Hi @AdailtonVentura ,

 

Which map visual do you use? Filled Map visual (fill range will change based on Location field name).

Rather than Map visual.

 

You may check if these thread help:

Solved: Incorrect map location - Microsoft Power BI Community

Solved: Wrong location in map - Microsoft Power BI Community

Map showing wrong locations even with country adde... - Microsoft Power BI Community

 

You may also use the Region keys in official document:

Use Shape maps in Power BI Desktop (Preview) - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @AdailtonVentura ,

 

Which map visual do you use? Filled Map visual (fill range will change based on Location field name).

Rather than Map visual.

 

You may check if these thread help:

Solved: Incorrect map location - Microsoft Power BI Community

Solved: Wrong location in map - Microsoft Power BI Community

Map showing wrong locations even with country adde... - Microsoft Power BI Community

 

You may also use the Region keys in official document:

Use Shape maps in Power BI Desktop (Preview) - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Caitlyn

AdailtonVentura
Regular Visitor

 

I am using a choropleth map with municipal division of the state of Paraíba (PB), Brazil (image 1). In the mapping, two municipalities have problems.

 

Image 1Image 1

 

 

 

 

 

 

 

 

 

  • Image 1

 

The table used as data source (all data is public):

 

Image 2Image 2

  • Image 2

 

 

I am using data category: LOCAL. It was the only category that worked correctly, using other categories (Cidade ou Município) did not work (Image 3).

 

 

Imagem3.png

  • (Image 3)

 

 

I made some changes to the names of the municipalities, but two mapping errors still persist:

 

1) FIRST PROBLEM: The municipality of Santa Cruz is being incorrectly mapped to a village in the municipality of Sousa (image 4).

 

Imagem4.png

  • (Image 4)

 

 

When the correct location should be here (Santa Cruz - region not selected):

Imagem5.png

  • (Image 5)

The municipality of Sousa is being mapped correctly.

 

Imagem6.png

  • (Image 6)

2) SECOND PROBLEM: The municipality of Quixaba is being incorrectly mapped to a village in the municipality of Uiraúna (Image 7).

 

Imagem7.png

  • (Image 7)

 

When the correct location should be here (Quixaba - region not selected):

Imagem8.png

  • (Image 😎

 

The municipality of Uiraúna is being mapped correctly:

Imagem9.png

  • (Image 9)

 

In Bing Maps it shows the problem with Quixaba - two local with same name:

Imagem10.png

  • (Image 10)

 

I followed the guidelines of the links given in the previous message and I also tried the state and city/city combination, but it didn't work (the whole region is colored - image 11)

 

imagem 11.jpg

Image 11

 

 
Any help would be appreciated, thanks!!!!