Even if you want to use USA Cities Map, or Cities of a specific state in USA you can’t find it here. For example New Zealand regional map is missing. There are few maps/shapes in this list, but obviously there are many options missing. You can simply change it to other maps in the list Now you can see that the default Map view is USA: States. To select to map, go to Format of this visual, and expand Shape section. The reason is that Shape Map works based on a predefined map. Start with using Region as the Location, and Use Population as Color Saturation.Īs you can see in above image, the first view would be States in USA, which is not exactly what we are looking for. To get the first view of this visual, you need to drag and drop a field into it.
POWER MAP PREVIEW FOR EXCEL CODE
Make sure that you get correct data types Region and Code should be Text, and Population should be Whole number Ĭlose and Apply query editor, and drag and drop a Shape Map visual in the report page. When you get data from Power BI Desktop from above data set, Power BI automatically change the data types to preferred data types.
POWER MAP PREVIEW FOR EXCEL DOWNLOAD
You can download all files for this demo here Īfter enabling the preview feature of Shape Map, get the data from Regions Excel file, which includes data set as below Why New Zealand? Regions of New Zealand can’t fit great into filled map (I’ve explained it here), so it can be a very good example for Shape Map then.
You should be able to see Shape Map visual in list of your visuals now.įor this example I will be using an Excel file including all New Zealand regions and population of each region. you need to close your Power BI Desktop and re-open it again. You need to select Shape Map in the list of Preview Features tab Īfter clicking OK. If you want to see an example of that, read this post Filled Map, the good, the bad, the ugly! Don’t get me wrong Filled Map is good at some stage, but there are better ways some other times.īecause Shape Map is still in preview mode (at least at the time of writing this post), you need to enable it in Options section of Power BI Desktop From File Menu -> Options and Settings -> Options. This feature makes it different from Filled Map, because the normal filled map visualize anything on a Bing map layer, and if for some reason it can’t find that geo location information result won’t be great with that. Shape Map is a visual first introduced few months ago with the ability to highlight regions (similar to Filled Map), and the power of adding your own map file to it. Hopefully at the end I will write a post about comparison. This post focus is on Shape Map, and in another post I’ll explain ArcGIS visual.
I have written about them all expect last two. Custom Visuals – Synoptic Panel by OKviz.There are many ways to visualize something on Map in Power BI, some of it are as below If you want to learn more about Power BI read Power BI from Rookie to Rock Star.
Let’s take a closer look at this visual with an example. The actual power behind it is that you can have your own map added to it. This visual is much more powerful than what it looks. This visual is still at preview mode at the time of writing this post. In this post I want to explain the power of Shape Map which is one of the visuals Power BI team published recently. One of them was specifically about Filled Map, titled as Filled Map the Good, the Bad, the Ugly! Why? you need to read that post to find the reason. I have previously written some blog posts about Map visuals in Power BI.