Incorrect MAP LOCATIONS in Power BI and how to fix it
Vložit
- čas přidán 22. 07. 2024
- 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!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ 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 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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 - Věda a technologie
This was really AWESOME, simple and well curated. Thank you!
You're welcome Wasif! Thank you for your fedback
Thank you! Exactly what i needed
Great. Thank you for your clear explanations.
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.
That's great. Is there a way to use different shapes instead of bubbles over maps. Please suggest if you have any workaround to show like balloon shape instead of a bubble for each country
Thank You so Much. Was stuck in this for hours.
Cheera mate 🥃
Respect from India 🇮🇳
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
nice you still managed to get it to work! 😀 I would first need a geography lesson
You solved my problem! Thank you!
Brilliant, you make things look really simple
thanks Tairu!!! 😃 I hope it does not only look simple, but is also simple to implement 😁
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!
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?
Hi, I'm trying to figure out how to define country name if I have only city names... can you advise please?
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.
Great tips, thanks Bas. Nowadays we can create a hierarchy for the location and plot that 🙂
Hi. Is there any option to disable relative sizing of bubbles while using slicers?
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?
Super .. much appreciated
Nice video. Have you figured out a way to not display latitude and longitude numbers in the pop up box when the cursor hovers over a location bubble? Even if you remove from tool tips, it is still there. Thanks.
no 🙁, you would need to use the custom tooltip if you don't wanna show the lat and lon
Thank you! adding country above city resolved the issue
great!
Thank you very much!
Thank you, really helpful😁
😊 glad to hear that it helped a bit!
thanks.. for this video.. i solved one my problem for my first Fiverr Client.. and i thank you too, i have successfully done that clients requirements.
👊😎 awesome
Thank you for this video
Thank you very much for this tip. This helps me a lot :D
happy to hear that! 😊😎
Thanks Basje! :D Very helpful. I was this close to call Microsoft and start cursing over the phone because of this LOL
Thank you Bas!!!!!!
2:55 adding new location column
happy it was helpful Saul! 🙂
Thank you so much!
💻🤓😎
1st idea worked! thank you! greetings from chinada
Awesome 😎👊🙌
Yoo!! Helpful as f !!!!! Thanks a lot :)) Cheers!
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)
Nice! Thank you!
thanks!!! 😃
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.
THANK YOU!
Thank you.. this helped fix my issue..
Thats great!
Hello sir in my desktop I can't see map visual it's blank ... what to do please answer
Would be useful to create a hierarchy for country - state - city data ?
If you were mapping assets rather then sales, how could you map multiple assets at a single address without the bubbles overlapping?
Thank you so much
How use other marks instead of circles, like pin points on Google map?
Just saved me :) - awesome and helpful video
Great to hear!
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.
Did you find the answer?
wow really helpful, I was facing the exact same issue, berlin was showing in the US, Thanks a lot.
good video with full of infos
thank you Enes!😃
That's why I ended up in Salvador in my last trip to Germany! rs
You are brilliant! thanks
haha Augusto, that's a different level, man... hope it doesn't happen too often ;)
Thanks again
Thank you, sir!
You are welcome Ciandra :) thank you for all your support!! ;)
U r rocking bro
Alwz come with magic👍👍👍👍👍👍💐💐💐💐💐💐
Thank you so much 😀
Note: Lat and long data need to be in World Geodetic System (WGS) coordinate system. If the data is in a projected coordinate system, it will show up in the wrong place. There are many free tools and software to convert between coordinate systems (e.g. QGIS).
Hi Ayman, thx for pointing that out! Do you maybe know some common example cases where projected coordinate system is used?
Any examples? I have only coordinates from Google Maps, and it is very off in ArcGIS map visual, and does not work at all for me in the others. Need to convert it somehow I guess..
Thanks!
thx for watching Tim! 😀
and how to hilights bubble ?
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.
Thank you Bas, keep producing all these possible mistakes, because that's what many of us encounter...😉
happy it was helpful! yes still many common mistakes to cover haha 😁
Wow!! Very nice..had no idea there was a city called Berlin in El Salvador...🤣👍
thx! 😁 I bet you'll never forget haha
Power bi is insisting on summarizing my latitude and longitude columns despite me classifying the data categories as latitude and longitude.
Music annoying
Oh..
Steve, you've clearly got too much time on your hands if you are wasting time on insulting others and their background music. He is simply trying to help people so if this isn't useful to you, then move on and keep your negativity to yourself. Appreciated!