Filter data in a 3D Maps tour

To see a subset of data in your 3D Maps tour, you might have tried filtering the data source in the workbook, but found out it has no effect on what's shown in the tour.

Tour with two filters set

To filter data in the tour, you can add and change filters in the Tour Editor pane. The picture above has a filter applied to show only California (CA) counties that have power plants with total capacity between 1000 and 5000 megawatts.

  1. In the Tour Editor pane, click Filter Filter button .

  2. Click Add Filters.

    Add Filters

  3. Choose the fields you want to filter, then click Add.

    Choose fields to filter

  4. Set your filters by using a Range filter (a slider bar), a List filter (check boxes), or an Advanced filter (criteria statements).

    Filters for numbers, text values, and dates

Do one of the following to set filters on the fields:

  • Set a Range filter by using the slider bar.

    In the picture above, a Range filter sets the Sum of Capacity (Megawatts) range between 1000 and 5000.

  • Set a List filter by choosing one or more check boxes.

    In the picture above, a List filter is set to show only data from power plants in CA.

  • Set an Advanced filter, where you can build multiple criteria statements.

    In the picture above, an Advanced filter limits the Initial Date of Operation to dates no earlier than 1/1/1968.


  • Use the button shown below to switch between a Range or List filter and an Advanced filter.

  • Switch between List or Text filter and Advanced filter

See Also

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.