How to filter a chart gadget
1 Select the gadget content. Filter appears, as shown in
Figure 4‑46.
Figure 4‑46 Filtering a gadget’s data
2 Choose Filter. Filter appears, as shown in
Figure 4‑47.
Figure 4‑47 Creating a filter
3 Select the following options:

Select the data column to filter. This example uses Measures/TotalSales.

Select the filter condition. This example uses Greater Than or Equal To.

Type a value. This example uses 100000.
4 Choose OK to apply the filter condition.
Optionally, choose Select Values to see a list of possible values. Choose Advanced Filter to create additional filter conditions. Clear Filter erases the current values.