Database Reference
In-Depth Information
In the following example, the
Professional
value is selected by clicking on it in
the pie chart legend. This action results in the bar chart display the
SalesAmount
value for only the selected
EnglishOccupation
in a dark color, with the overall
values in a lighter shade. Values in the two tables are also filtered by the selected
ProfessionalEnglishOccupation
.
Interactive cross-filtering
Slicers
Slicers are a type of filter and are identical to the slicers you find in Excel. They filter
everything in the view or sheet. To build one, you first create a single-column table
from any attribute field, select the table, and click on the
Slicer
button. Each value in
the table becomes a button, and when you click on the button, the data is filtered in
the report immediately. You select multiple values by holding the
Ctrl
key when you
click on each button. There is a
Clear Filter
icon at the top-right of each slicer that
resets the filter, resulting in all values being selected. You can then click on any value
to deselect it.
