There are two ways to create a quick filter for the bubble chart layer in the Excel Map: if you are Excel 2013+ user, you can create a slicer or you can create a non-standard filter based on your list.
What is the best way to quickly compare your results on a map between consecutive years? Check the Choose data range option that allows you the quickly switch between various options.
A dashboard is usually a collection of charts and tables combined with interactivity for the end user. Excel Map software allows the user to easily create interactive dashboards using pivot tables and slicers. This example is based on a Excel Map UK but can be applied to any of the maps.