• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Power View Maps differs from Excel and Excel services and how to solve it

November 16, 2014   Self-Service BI   No comments
September 30, 2014 / Erik Svensen

Power View Maps differs from Excel and Excel services and how to solve it

I have created a model based on data from http://www.scb.se/en_/ to visualize the number of households in Sweden.

The data was split by municipalities and I could also find a list of municipalities and their link to Swedish regions – and then it was no problem plotting these in a power view sheet in Excel

 Power View Maps differs from Excel and Excel services and how to solve it

And the user can double click the region to drill down to municipality level

 Power View Maps differs from Excel and Excel services and how to solve it

Very nice – and I was ready to deploy the model to Sharepoint – Excel Services so the users could browse the model online.

But what a surprise when I double clicked the Stockholm region in Excel Services…

 Power View Maps differs from Excel and Excel services and how to solve it

Suddenly I have a municipality in Unites States – Salem – it turns out that the map in Excel services ignores the map hierarchy information from the parent – so it picks the first Salem returned by the Bing Maps Service.

So I added a calculated field in my Map table where I combine Municipality and Country – and mark it as County in the Reporting Properties – Data Category.

 Power View Maps differs from Excel and Excel services and how to solve it

And know it works in Excel Services as well when drilling down in the Stockholm Region

 Power View Maps differs from Excel and Excel services and how to solve it

It works like expected in Excel services as well.

So you might consider to add the country to all your locations just to be on the safe side, when you don’t have latitude and longitude for the locations.

Filed under Power View
← Specifying JSON Query in Power Query – Example Statistics Sweden
Clean your customer master data with Excel 2013 and Public data →

This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

Erik Svensen

differs, Excel, from, Maps, Power, Services, solve, View

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • Recent Posts

    • C’mon hooman
    • Build and Release Pipelines for Azure Resources (Logic Apps and Azure Functions)
    • Database version control: Getting started with Flyway
    • Support CRM with New Dynamics 365 Field Service Mobile App
    • 6 Strategies for Achieving Your Business Goals in the New Year
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited