keropfa.blogg.se - Map chart excel 2016 cities

We can easily overcome the issue by adding a calculated column to the table and concatenate “Country” and “City” columns so that the Bing Map engine finds the correct cities. What happened is that Bing Map Engine gets confused with the city names so that it shows a city with the same name outside of the US, just like New Plymouth which a city in New Zealand, but, the New Plymouth we have in our data source is the New Plymouth from Idaho in the US.įixing the Wrong Cities Issue In Power BI Solution 1: Concatenating Country and City in Power BI Click “United States” to filter the Map.Put a slicer on the page then put “Country” on the slicer.Select “City” column then change its Data Category to City (Data Category is on “Modeling” tab from the ribbon)Īs you see sales distributed across different countries, but, this is not quiet right.Map Issues In Power BI Wrong Cities in Power BI Select Fact.Sales and Dimension.City then load data.If you use Excel 2016, then you need to turn on Power View on.Ĭheck this out if you want to learn more about BI features in Excel 2016.

The latest version on Power BI Desktop (current version is.

The new SQL Server sample, WideWorldImportersDW (WWI).

To experiment everything I explain in this post you need to have: My intention is not explaining Power View and Power Map that much so my focus in this article would be on Power BI more than the other two. As “Filled Map” and “Map” visualisations in Power BI are very similar my focus in this post would be on “Map” visualisation. In this post I address some of the issues I faced myself and I’ll provide the solutions for the issues.

But, there are some issues with Map visualisations in both Power BI and Excel. They work beautifully if you have enough data supported by Bing Maps. In Power BI, as you know, there are two built-in visualisations supporting geographic coordinate data, Map and Filled map. In Excel we can use Map visualisation in Power View, or use Power Map directly. One of the most powerful features in Power BI and Excel is supporting geospatial visualisations.