Map visual

Question

Hi All,&nbsp;I am creating map visualization for seaport details. I have port country and port name.&nbsp;&nbsp;Ex: Port country : India, Port name: vizag, mumbai, haldia, ennore and 4 more ports ( Totally 8 ports)&nbsp;I got output like :&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Data category&nbsp;(Port Name) &nbsp; &nbsp; &nbsp; Port NameBI Desktop &nbsp; &nbsp; &nbsp; &nbsp;uncategorzied &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 port showing ( 1 port position&nbsp;was wrong : Jawaharlal Nehru Port was in &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mumbai,But it was showing in Goa)BI Service &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;uncategorzied &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 port only showing ( ennore &amp; vizag). very rare time it was showing 8 portsBI Desktop &nbsp; &nbsp; &nbsp; City \ Place \ address &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2 port only showing ( ennore &amp; vizag) remaining missingBI Service &nbsp; &nbsp; &nbsp; &nbsp; City \ Place \ address &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2 port only showing ( ennore &amp; vizag)&nbsp;remaining missing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Why it was showing 2 ports only?What the reason map was showing 2 places sometime, 8 places sometime?Is there way to show port name accurately in map visualI have attached Port Details link. Please test it and give the solution.&nbsp;ByGnannasekar

burningsuit · Answer

I've found the maps often need more information than simply a town or city name to find the location. The more data you can give the better The best is to have a table of Port Names and Latitude and Longitude, which will always work. A quick look found the following website that gives the latitude and longitude for each Port.

http://www.gccports.com/search/latitude_longitude.php

gnanasekar · Answer

Hi&nbsp;Burningsuit&nbsp;Thank you. Why Mumbai&nbsp;was not showing in map? It is a city and spelling also same with map.&nbsp;By&nbsp;Gnanasekar

burningsuit · Answer

Looking at your "Port Details" example it looks like your data is attempting to map "India, Mumbai", and "India, Sikka", what is happening is that the map places a dot for "india" in the geographic centre of "india". So you are actually only getting one dot per Country, not per Port. You may get better results if you turn it around and map "Mumbai, India" rather than "India, Mumbai"

If you use the ESRI map in Desktop, you can specify the country that the datapoints lie in, which may give a better location for your data.

Regards

Stuart

gnanasekar · Answer

Hi&nbsp;Burningsuit&nbsp;Their two columns were present not a single column. (Port country &amp; Port Name)I was used hierarchy&nbsp;in map visual.It was showing port country now. Please drill down and see how many port names showing there.&nbsp;&nbsp;Please select Mumbai, Sikka&nbsp;in port name slicer and see&nbsp;map in port name level.&nbsp;&nbsp;Hierarchy was presented now like&nbsp;Port country then Port name. If I give port name then port country, it also showing same value there.&nbsp;By&nbsp;Gnanasekar

burningsuit · Answer

Hi&nbsp;Gnanasekar&nbsp;I've had a go with your data, take a look at&nbsp;this report I've increased the accuracy of the map by appending the country to the port name. It seems to work fine with most examples "inda,Mumbai" "India,sikka" for example. The only fail is on&nbsp;Jawaharlal Nehru Port. Look at page 2 to see the data. Drill down works, and selecting the individual ports work (except&nbsp;Jawaharlal Nehru Port).&nbsp;

Forum Discussion

Map visual

10 Replies

Related content

Map visual not enabled

Map and filled map visuals are disabled

Enable Map Visual

Azure Map Visual

Map and filled map visuals aren't enabled