PowerMap Changelog. PowerMap gives you the power to map views of entities within CRM. Pick an entity, pick a view and PowerMap plots the points. Version: 4.0.6.0 Date: 7/26/2021-Bug fix: Fixed the issue where users were unable to upload more than 1000 records to a marketing list and were unable to assign an owner. Power Map for Excel–May update for Office 365. Today’s post was written by Igor Peev and Daniel Witriol, program managers on the Power Map team. In the May 2015 update of Office 365 we are proud to introduce a new core feature to Power Map: Custom Regions. The Custom Regions feature allows data to be mapped to the regions that matter most.

This blog post was authored by James Marshall, Developer on the Excel Power Map team

• Microsoft Excel Power Map Excel 2013. Power Map is a 3-D data visualization tool in Excel 2013 and Office 365. Get started with Power Map in Excel 2013. Power Map has been renamed to Microsoft 3D Maps in Excel 2016, and is located on the Insert tab in the Excel ribbon. Get started with 3D Maps in Excel 2016.
• Alternatively, you can use the same procedure to install Power Map, Power View. Excel 2019 / Office 365. Note: A far as i can tell, the Microsoft Data Analysis add-ins are now shipping as part of all Microsoft Office 365 subscriptions as well as Office 2019 Home, & Business and Home & student and Professional versions.

In early September, we introduced you to Custom Maps, a new feature in Power Map for Excel. Power Map is part of several analytics and visualization features, such as Power View, that comes with Excel when you get an Office 365 subscription with Office Professional Plus. You can get enhanced versions of these features as part of Power BI for Office 365, our cloud-based solution for analyzing, visualizing and sharing data insights across your company or organization.

In this post I’ll show you the basic steps for how to create a custom map with Excel Power Map. All you need is (1) an image with your custom map and (2) data that you can map in an XY coordinate system/plane. That’s it! Let’s get started.

To illustrate the process from start to finish, we’ll walk through the creation of a Custom Map that visualizes train routes on the imaginary island of Lunda.

1. First, you will need an image: any jpg, bmp, or png file. In this case, we have a map of the island with various cities and paths of trains plotted. Here’s is the one that we used for this example:

2. Next, it’s assumed you have some data which relates to the image. For this example, we have the number of passengers on the train routes at given intervals throughout the day.

3. Power Map needs a way to plot your data on an X, Y coordinate system. One such mapping is the pixel placement of where you want your data to appear. In our case, we want to show the total number of passengers on the cities, so we need the pixel position of each city. This is simple enough to do by opening Microsoft Paint, hovering over a city with the mouse, and recording its pixel position in the bottom-left hand corner of Paint into X and Y columns in Microsoft Excel. Repeat for each city.

4. Now that the data mapping is complete, boot Power Map and select New Scene > New Custom Map. Select the “Geography” of the Custom Map, which will be the X and Y Coordinate System in the Layer Pane on the right. In the Custom Map Options dialog, click the “Pixel Space” button as we’ve already created a one-to-one mapping of the data to the image. If you’re not mapping your data by pixels, there are options to scale and offset your X and Y data in this dialog.

Office 365 Excel Download

5. Click Apply in the dialog and “Next” in the Layer Pane. Now, you can use Power Map just as you would with any geographical data. Add value and category fields, select colors, and play your tour when you’re finished!

Microsoft today announced updates to Excel Power Map with two big features, Power Map Filtering and Custom Maps, to make your experience using Power Map easier and more exciting. Power Map is an nteractive data visualization features within Excel, which are enhanced with Power BI for Office 365, a cloud-based solution for analyzing, visualizing and sharing data insights.

• Power Map includes the ability to filter data using three different options:
  • List filter. Let’s you select or exclude individual categories. The data is listed in alphanumeric order, and only the first 50 in the list are shown. You can use the search box to narrow down your results and get to the rest of your data. Simply select the All check box to remove any filters.
  • Range filter. The slider helps you filter a numerical field between the minimum and maximum values. Both the minimum and maximum are inclusive—in other words, “between” means including.
  • Advanced filter. Use predicate statements, such as “is greater than 1000” or “is after 8/01/2014” to filter your data with pinpoint precision.
• We took data visualization to an entirely new level by introducing Custom Maps, which extends all the existing features of Power Map, so you can tell rich and interactive stories using any map. Just choose an image—like a building floor plan, a map of public transit routes, or a system architecture map—and quickly transform your data into a powerful and dynamic visual story.

Office 365 Excel Power Query

If you have an Office 365 subscription with automatic updates enabled, you should receive this update soon. If you don’t have automatic updates enabled in Excel, go to File > Account > Update Options > Update Now.

Office 365

Read about this update in detail from the below link.

Office 365 Login

Source: Office blog