Unlock Power BI MAP Visualization: Must-Know Maps Tutorial (2023)!
HTML-код
- Опубликовано: 2 авг 2024
- Power BI Map Visualizations! Delve into the world of Power BI MAP visualization with our insightful tutorial, highlighting five essential maps you must know in 2023! Gain a comprehensive understanding of mapping techniques, from basic setups to advanced features. Follow our step-by-step guidance to create impactful geographical visualizations that enhance your data narratives. This tutorial is designed to cater to both beginners and experienced users, providing practical examples and expert tips to maximize the effectiveness of MAP visualizations in Power BI. Stay ahead in data visualization trends for 2023 and elevate your skills with this must-watch tutorial!
In this Power BI map visualization tutorial, I will explain how to utilize all five map Power BI visuals.
You might be wondering, what are the differences between the Power BI map visuals? Don't worry, I will show you everything you need to know to leverage all the Power BI map visual features and functionality. This map tutorial will educate and inform both the advanced power bi dashboard developer as well as be a power bi tutorial for beginners.
Follow along using the same file!
Filename = PBI - 20231220 - Maps.pbix
github.com/powerbibro/powerbibro
Featured Map Options:
• Data Map: Explore the foundational Data Map for basic geographical visualizations. Learn how to bring your data to life on a global scale!
• Filled Map: Elevate your visuals with the Filled Map option. Dive into the art of color-coding and shading to convey data nuances effectively.
• Shape Map: Unleash creativity with the Shape Map. Customize your visuals using custom boundaries and transform your data into stunning, unique representations.
• ArcGIS Map: Delve into the world of advanced mapping with ArcGIS integration. Learn how to harness its power for intricate spatial analysis.
• Azure Map: Discover the capabilities of Azure Map for a cloud-powered mapping experience. Elevate your insights with dynamic, real-time location data.
Timestamps:
0:00 - Power BI Map Visualization Tutorial Introduction
0:40 - Prepping Your Geo Dataset
4:57 - Unveiling Data Map
10:18 - Elevating Insights with Filled Map
14:10 - Shaping Your Data with Shape Map
17:03 - Advanced Spatial Analysis with ArcGIS Map
21:18 - Cloud-Powered Mapping with Azure Map
#powerbi #powerbidesktop #powerbibro #powerbitutorial #microsoftfabric
#datavisualization #dataanalytics #businessintelligence #dax Наука
You get right into information which is what I appreciate the most!
Thank you!
Nicely done - very useful
Thank you!
Nice one very useful
Thank you!
Thank for your guidance !
My pleasure!!!
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!
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.
ruclips.net/video/I4ewYX04D4c/видео.html
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?
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
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.
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.
ruclips.net/video/hI-TdZiRke0/видео.html
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.
Performance has improved from what I've seen. Please let me know how it goes for you after you try it out!
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?
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
I have similar requirements and am still yet to find a suitable map.
Please, the link of the datasets....
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
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.
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).
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 ☺️
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
@@PowerBIBro Thank you! I will take a look on it!
My Power BI Desktop looks different from yours - could it be because of updates? I'm on a Power BI Pro plan from work
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?
@@PowerBIBro Version: 2.129.905.0 64-bit (May 2024)
looks like it's the latest one!
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.
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.