Publishing Your BI Tools to SharePoint - Microsoft Business Intelligence Tools for Excel Analysts - page 302

➤ Disable the cross-filter behavior for some slicers. Disabling the cross-filter behavior of a
slicer essentially prevents that slicer from changing selections when other slicers are clicked.
This prevents the need for Power Pivot to evaluate the titles in the disabled slicer, thus reduc-
ing processing cycles. To disable the cross-filter behavior, right-click the target slicer and
select Slicer Settings. In the Slicer Settings dialog box, deselect the Visually Indicate Items
with No Data check box, as shown in Figure 15-12.
Figure 15-12: Deselect the Visually Indicate Items with No Data check box to disable the slicer's cross-filter behavior.