Tip:
Highlight text to annotate it
X
Power View has many different ways to slice and dice the data. Filters remove all but the data I want to focus on.
To filter data in Power View, I can use Filter Pane filters, slicers, and cross-filters. This video covers Filter Pane filters. Let’s start by
opening the Filters Area. I do this by selecting from the Power View ribbon or by hovering over a visualization and clicking the Filters icon.
Filters that I create here are saved with my report. I can create View-level filters and visualization-level filters.
View-level filters are applied to the entire Power View sheet. If this Excel file contains other Power View sheets, they aren't affected by filters
I add here. I create a view-level filter by dragging over a field or right-clicking a field and choosing Add to View Filter.
When I drag over Season and filter for Winter, all related visualizations in this view are filtered for Winter. My pie chart and matrix now show only
winter sports. But my population chart is unchanged since the data displayed is not impacted by season.
Visualization-level filters are applied to only the selected chart or table or matrix or card – watch the label change based on which visualization I
select. And when I first open the visualization- level pane, it's already populated with the fields from the visualization.
I’ve already filtered the Country Name field to include country/regions that have won medals at the winter games. Power View displays the
names and the total number of country/regions selected. But my Population chart is still crowded with many country/regions.
And the significant difference between a few country regions with large populations makes it hard to read and select the other bars in the
chart. So I'll set a visualization-level filter on the Population chart.
I'll filter out the largest country/regions and the small miscellaneous groups the Population dataset contains.
I first try using the slider to filter by population. It’s not giving me the precision I need so I switch to the advanced filter.
I first try using the slider to filter by population. It’s not giving me the precision I need so I switch to the advanced filter.
I use the advanced filter to select country/regions with more than 100,000 and less than 30,000,000 people.
I first try using the slider to filter by population. It’s not giving me the precision I need so I switch to the advanced filter.
Now I no longer have one tall bar and lots of bars that are too flat to be meaningful.
I can use this chart as a filter as well. By clicking individual bars, I filter the other visualizations in my report view.
As we saw earlier with the Population table, there are several way to configure a filter. These are called Modes. Each filter has two or
more modes. To switch between modes, use this arrow icon. Available filter options depend on the data type of the field being filtered.
Numeric data has sliders (also called Range mode) and Advanced mode.
Non-numeric data has List mode and Advanced mode. To clear a filter, click this eraser icon.
I can search in List mode, by typing in the Search box, and then choosing to filter on it or not.
And I can Search in Avanced mode as well. In my pie chart, I'll filter out Ice Hockey.
And I can Search in Avanced mode as well. In my pie chart, I'll filter out Ice Hockey.
Because this is a visualization-level filter, Ice Hockey is filtered from the pie chart but not from the matrix.
And when I click the eraser icon, Ice Hockey reappears. Clicking the eraser clears the filter, it doesn't delete it.
To delete a filter, click the X icon. You can't delete a field if it's in the visualization, you can only clear the filter.
One last tip for working with filters. I can use wildcard characters in my searches. A question mark matches any single character. Here it
matches all the country/regions that have an R and an N and any other letter between the R and the N. An asterisk matches any sequence
of characters between the R and the N.
Please visit office.com for more information.