Select Page

Excel Video 506 Filtering in 3D Maps

May 2, 2016Excel 2016, Maps

Excel Video 506 introduces filtering in 3D Maps. I hope you’ll be pleasantly surprised at the variety and flexibility of the filtering options available. You can manually filter items as you’d expect, but filtering in 3D Maps also has advanced and/or functionality as well as the ability to aggregate filtered items. Watch how I use the aggregation feature to filter by the distinct count of items in my dataset. To get distinct counts in a Pivot Table you have to use PowerPivot. (Stay tuned. PowerPivot will be a topic of many future Excel Videos.) Distinct count is available now in 3D Maps, making your filters even more powerful.

Note how I can filter by items in the map as well as items that are not displayed on the map. Also watch how I can click to add fields to filter by. I can also drag items from the field list to the filter area to create new filters.

We’re just scratching the surface of what 3D Maps can do. Stay tuned and we’ll continue exploring 3D Maps. I look forward to seeing you then.