Incorrect MAP LOCATIONS in Power BI and how to fix it

preview_player
Показать описание
Incorrect map locations in Power BI can be difficult to fix. How to make sure your data shows correctly on a map? In this video I will show you how to fix your map visualizations it with different approaches and what to watch out for. Enjoy!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:38 Creating a map visual
1:50 Solving incorrect mapping: first option
2:54 Solving incorrect mapping: first option
4:09 Why you need to set the data category for each location field
5:19 Creating a map with latitude and longitude
9:22 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX
Рекомендации по теме
Комментарии
Автор

The issue is that when we add the coordination to enhance the data when the latitude and longitude are blank there will not be any bubble in the map and it Will not try to resolve it using only the address ( knowing that the address itself is enough in this case)

TheHoussem
Автор

This was really AWESOME, simple and well curated. Thank you!

wasifqureshi
Автор

Nice video! My doubt is: in my Power BI desktop the locations are right but when i share it online this problem happens.... how can i fix this if my document in desktop visualization is perfect but online goes bad?

raul
Автор

I'm closer now. Just have one location showing in Naples, Italy instead of Naples, Florida. I've confirmed that the Street Address as Address, City Name is mapped as a City, State as a State or Province, Country Name as a Country, ZIP/Postal Code as a Postal Code.

GuardiansFortress-rrtu
Автор

Hey Bas, thank you for your awesome tutorial. It helped me a lot. I need some help for a particular task. Can you please make a tutorial on how to show dot density in bing/google map? For example if New York has 50 shops, I want to show 50 points/dots in New York in map. Can you help me do this?
Looking forward to your reply.

saminhasan
Автор

In the vid Bas talks about New York being both a city and state, it's even more complicated then that....

New York is the five borough and each borough is a county. BUT only two counties have the same name as the borough. Brooklyn is a borough in new York, a city in new York state but is also kings county!!!

I used Bas's instructions but made an additional column for borough and defined it as a "place".

Combing the columns as "address", "county", "borough", "city", "state" got the job done

joecahill
Автор

Hi, I'm trying to figure out how to define country name if I have only city names... can you advise please?

mykavkaz
Автор

Would be useful to create a hierarchy for country - state - city data ?

FabioRBelotto
Автор

Hello sir in my desktop I can't see map visual it's blank ... what to do please answer

snehalnalawade
Автор

Thanks!! I realized running dashboard in a Windows machine city name is enough for the visuals. However in IOS you have to append Country too otherwise dashboard will be with no locations.

ismaelpfa
Автор

Hmm for me it still shows e.g. Manchester somewhere in Jamaika instead of England. I used first continent then country then state for the graphic and made it a drill down like you explained. Any idea what the reason might be?

Pl-xtye
Автор

Power bi is insisting on summarizing my latitude and longitude columns despite me classifying the data categories as latitude and longitude.

TexasCoffeeBeans
Автор

Thanks Basje! :D Very helpful. I was this close to call Microsoft and start cursing over the phone because of this LOL

danieleconserva
Автор

If you were mapping assets rather then sales, how could you map multiple assets at a single address without the bubbles overlapping?

KevSmu
Автор

Hi, Is there any solution to define the MENA region which combines of Qatar, UAE, SAudi Arabia, Israel etc and when i select Region as MENA the corresponding map is filled with color defined for MENA.? I have 7 regions which includes africa, south america, , north america, mena etc. Only MENA region isnt recongnised in the map whereas all others are higlighted .Could you help on this? I am defined data based on regions which has multiple territories.

fiz-
Автор

Thank you so much! It helped me a lot!

danielrugerio
Автор

1st idea worked! thank you! greetings from chinada

catfat
Автор

This was a great video! I was stuck and could not figure out how to show that sales in the state of Arkansas (AR) were not actually in Argentina!

djstearns
Автор

Great tips, thanks Bas. Nowadays we can create a hierarchy for the location and plot that 🙂

garyknott
Автор

Thanks, your video helped me out! Turned out I had given the country column accidently the category "county" instead of " countRy"... And suddenly the maps were completely messed up.

ctphilippi