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.
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.
Read about this update in detail from the below link.
Source: Office blog