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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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!!!!