Power BI MAP Visualization: Must-Know PBI MasterClass!!!

[@sandrilakingdom9106]

Wow... thanks alot

[@PowerBIBro]

My pleasure and thank you for sharing!!!

[@maoavila1]

Do you have a video explaining how to use filters on a map visualisation? I want to learn how to show different column values in one map. Thanks a lot for your channel!

[@PowerBIBro]

Thanks for reaching out and I'm glad the video is helpful! To confirm, are you wanting the end user to be able to select from different measures and them flow into your map... examples, maybe sales, profit, and units - you'd like the user to pick one of these. If so, the answer is to create a field parameter. Here's some documentation from Microsoft. I don't have a specific video on this but I do create them in my scatterplot video. If you watch that, you'll see how to create field parameters, then you can apply these to a map. Microsoft. learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters Power BI Bro - Scatterplots... there is a chapter on field parameters. kzbin.info/www/bejne/f2XIqIyOZZl3asU

[@mathew9665]

Nicely done - very useful

[@PowerBIBro]

Thank you!

[@maoavila1]

Thank for your guidance !

[@PowerBIBro]

My pleasure!!!

[@christophmeirich5928]

Thx for sharing :-) How do you calculate longitude and latitude? Thx in advance!!!!! Greetings from Germany Christoph🙂

[@PowerBIBro]

Thanks for your support and your question? To confirm, are you wanting to visualize long and lat or are you trying to calculate the values? The values ‘coordinates’ themselves need to provided to PBI as a source vs calculate them. If your needing some additional help with visualizing them, the below web link may help! learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

[@mathew9665]

Nice one very useful

[@PowerBIBro]

Thank you!

[@giri-w5l]

Excellent work bro. But I try to implement map visuals it shows errors contact your tetant admin. What is it. Please explain

[@PowerBIBro]

Great question and happy to hear you think the video is excellent! In order to utilize these features, your tenant admin who manages your PBI Service, needs to enable some Azure map settings. Check out this article below which provides more details and let me know if this helps! learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-manage-access

[@AbimbolaAgunloye]

I have a requirement in Power bi where i need to visualize states in Puerto Rico alongside states in USA, i am struggling to achieve this. Can you help point me in the right direction?

[@PowerBIBro]

Offhand, does Puerto Rico have states or municipalities? I don’t think it’s apples to apples with “states”. You so may consider using 2 maps, a filled map for the USA and a long.lat value for the Puerto Rico locations

[@lijunchen]

A very informative tutorial. Thanks for posting this. But when replicating the map visual, I found a bug in the map visual showing the bubble for NYC. When drill down to NYC, the location for NYC bubble is no in NY state, but near Georgia, separated from all other city bubbles in NY state. I don't know what is the cause of the issue. Can you check the map visual and see whether you have the problem too.

[@PowerBIBro]

Thank you for sharing this comment! I took a look into it and it is most likely a data issue. If you look at the raw data, via creating a table with the columns 'State, Latitude, Longitude, Country, City'... filter to NY. You'll see there is a single Long/Lat (which may be the cause of the issue if it's incorrect).

[@Alexanderr-n8e]

Hi Power BI Bro, I was looking to create a heat map with the Map Visual but in the visual settings there isn't a heat map button, should i enable anything to obtain it?

[@PowerBIBro]

Excellent question and thank you for reaching out!! A heat map is certainly possible, but it will only work on the Azure Map. If you check out the below article it should provide some additional details. learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-add-heat-map-layer

[@michaelb3254]

Thanks for the video. My company has sales territories that are not divided up cleanly between state lines. For example, we have two territories for Texas and three for Florida. We get our sales data broken out by territory, but I'm not seeing a way to create a map that divides the states according to the territory boundaries we have created. Is this possible? I have an internal map showing our territory breakdown, but it's a flat pdf file, so it doesn't correlate to anything interactive in PBI. Thanks again.

[@PowerBIBro]

Love this question and thank you for sharing! There is a way to solve this, check out the latest video I just posted (link below). The July 2024 update included a Reference Layer update associated with Azure Maps. Essentially what you'll need to do is create a geojson or kml file which contains the boundaries of your territories. In the video below you can see that I do this same thing for Chicago neighborhoods. kzbin.info/www/bejne/nnqQhZeQnreem5I

[@BilalMakki-kf4dy]

I have a requirement in Power bi where i need to visualize each project map in a shape/filled area of specific Plot, i have coordinates, for normal map it's show in a bubble, but the requirement is that it should filled that specific plot area, please guide

[@PowerBIBro]

This is a great question and thank you for asking it! Have you looked into the details of what's available in Azure Map reference layers? Below is an article with some detail, let me know if this helps point you in the right direction. learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-add-reference-layer?tabs=upload

[@martybr91]

Hey! Thank you for your video. I’m having an issue that you might be able to help with :) when trying to use the filled map for neighbourhoods in London, I does not recognise the gradient of color. It shows everything in the same color. Do you know what can be happening? I added a category to the neighbourhood field, checked the other numeric field used in the conditional.Everything seems to be ok. Not sure what I’m missing. Thank you in advance ☺️

[@PowerBIBro]

Thank you for your question! You may have to use a more complex TopoJSON file. It's hard to diagnose for sure without seeing your dataset, but I think this may help. Here's a guide specifically for using the ShapeMap with London neighborhoods, hopefully this can help with some direction on the TopoJSON files. Power BI Shape Map - LONDON (WITH BOROUGHS) datawise.london/assets/documents/power-bi-resources-how-to-cr-2

[@martybr91]

@@PowerBIBro Thank you! I will take a look on it!

[@techp0p]

My Power BI Desktop looks different from yours - could it be because of updates? I'm on a Power BI Pro plan from work

[@PowerBIBro]

Yes it’s most likely a version issue, hopefully you are on a newer version :) If you go to the about menu in your Power Bi Desktop App, what month does it display for your version?

[@techp0p]

@@PowerBIBro Version: 2.129.905.0 64-bit (May 2024) looks like it's the latest one!

[@HappywithCath]

You get right into information which is what I appreciate the most!

[@PowerBIBro]

Thank you!

[@bradj229]

I've postponed adopting the Azure map because the performance was terrible on my first few experiences. It took way too long to load vs the standard map. Hopefully that's been fixed.

[@PowerBIBro]

Performance has improved from what I've seen. Please let me know how it goes for you after you try it out!

[@AakritiJain-j5r]

How can I add location pins on a filled map?

[@PowerBIBro]

Great question! To "drop pin" locations on a shape map in Power BI, you need to ensure your data contains latitude and longitude coordinates for each location, then use the "Shape map" visualization type, dragging your location data (which should include the latitude and longitude columns) into the "Location" field on the visual pane; this will automatically place pins on the map based on the geocoded coordinates.

[@kennethguerra]

Hola, has creado un mapa temático en power bi, donde el universo de puntos es de 3000 mil. y solo quieres que los que tuvieron oferta se pinten de verde y los que no se pinten de rojo. Lo he intentado pero cuando paso la venta solo muestra los que tenían oferta.

[@PowerBIBro]

Hi. There are a couple of different ways to solve this, I would start with focusing on levering the "Legend" field of the Azure Map. First update your dataset to include a 'calculated column', (not calculated measure) with has true/false "Has Offer" column for each row. Then... in Azure map, add geolocation field to Location, then the measure to size, and the new Has Offer field to Legend.

[@owoadebamidele8000]

Please, the link of the datasets....

[@PowerBIBro]

Thank you for your question! I can certainly provide info on the dataset utilized. For this maps video, I used Kaggle's Billionaires Statistics Dataset (2023). You'll see the power query in the PBI file has a series of transformative steps, but the raw data can be found below! Enjoy! www.kaggle.com/datasets/nelgiriyewithana/billionaires-statistics-dataset

[@onelangelsanchez9003]

Can I make it work using zip codes?

[@PowerBIBro]

Most certainly! To use zip codes in maps, you’ll want to set the data type of the zip code to geographical

[@seedmatrix]

I can't figure out how to add layers to a map. I am using the ArcGIS map. I currently have each county colored based on my companies sales. Now I want to add a dot for each store that we have. We currently have about 800 stores. I would also like to add a division boundary overlay. Each division is made up from a group of counties. Thoughts?

[@PowerBIBro]

Hi! Great question and thank you for reaching out. ArgGIS map overlays are possible, however describing how to accurately implement them for your specific dataset is challenging. A great next step would be to check out the ArgGIS 365 layers documentation below, scanning through the various tabs of documentation as well. doc.arcgis.com/en/microsoft-365/latest/get-started/layers.htm

[@cathychen2112]

I have similar requirements and am still yet to find a suitable map.

[@analytic_panda]

a comprehensive lecture, but given my experience teaching this stuff in a college, I suggest you go much slower for beginners...

[@PowerBIBro]

I really appreciate this feedback and thank you for sharing! I am thankful for your support and will take this advice into consideration with future videos I create!