cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Help with plotting Pincodes to power BI Maps

 

Hi All,

 

I have a dataset with a list of Indian pin codes to be plotted on the power BI maps. I have tried various options stated in the power BI forum like chnaging data category, renaming pin code to zip code etc...but none of them have worked so far. 

The only thing that Power BI is able to plot is the name of the city correctly, but for my requirement, I would want to show each postal code on the map as my data is arranged that way.

 

I have attached below a snapshot of the map that shows a small sample with a field called "Geo Code" and concatenated by city name, Zipcode and State name. This has set of 40 pin codes in it(meaning 40 rows of data) but the map showing only 1 postal code accurately as shown below:

 

Power BI Map showing a single data point on the map(instead of 40 required points) with the calculated field "Geo Code"Power BI Map showing a single data point on the map(instead of 40 required points) with the calculated field "Geo Code"

Could somebody help me out with this? Also, is this a problem specific to Indian pin codes?

 

Note: Currently I do not have the lat-long information for this data. 

7 REPLIES 7
Highlighted
Super User IX
Super User IX

Re: Help with plotting Pincodes to power BI Maps

Power BI uses Bing for geocoding so if it is not recognizing Indian pin codes, you may have better luck getting an answer on the Bing developer forums.

 

https://social.msdn.microsoft.com/Forums/en-US/home?category=bingmaps

 

https://www.microsoft.com/maps/developer-resources.aspx

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Champion
Community Champion

Re: Help with plotting Pincodes to power BI Maps

Pin Codes.png

I couldn't get it to work either - tried different concatenated combinations for Location - this is the best one I got but clearly wrong.

 

Anyway let us know if you find a solution/answer.

Highlighted
Community Support
Community Support

Re: Help with plotting Pincodes to power BI Maps

Hi Mathangi_S,

 

According to your description, you have 40 records in data, but there will not display 40 pin codes in the map, right?

 

Based on my test, we need to concatenate location value and pin code value in a new column, then specify map location property with this new column. All pin codes will be plotted. Please refer to screenshots below:

 

w1.PNGe1.PNG

 

From your image, I noticed that the one point displays outside of the India (eg: Ajalser). I guess there might be another points which is outside of India and you need to zoom out the map to check.

 

If issue persists, please share your data for our analysis if possible.

 

Best regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Help with plotting Pincodes to power BI Maps

Hi Qiuyun_Yu,

 

I have tried the city + pin code concatenation and it doesn't work in my case, the reason being there are several pin codes within each city itself which needs to be plotted. And by 40 rows of data, I actually mean 40 such concatenations in my dataset for the column "Geo Code".

 

It would be great if you could help me plot the sample dataset I am sharing with you which has pin codes, city and other address information only for the Chennai city as I need each pin code value to be separately detected for showing sales/revenuew values for each pin code at a later stage!

 

Also, could you please let me know how to share my data because I don't see an option in this forum to do that?

 

 

 

 

 

 

 

 

Highlighted
Frequent Visitor

Re: Help with plotting Pincodes to power BI Maps

Hi All,

 

Anybody else who can help me on this?Also, it would be great if you can let me know how to share my dataset?

Highlighted
New Member

Re: Help with plotting Pincodes to power BI Maps

Was this solved? I'm having a similar problem with Power Maps in Excel.

Highlighted
New Member

Re: Help with plotting Pincodes to power BI Maps

Was this ever solved? I'm having a similar problem with Indian Zip Codes.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors