Syncing the slicers

Pam knows that she wants to keep the slicers in the CONTROLS area in sync across all of the pages of the report. This means that, when a slicer is changed or adjusted on one page, all of the other pages of the report should reflect this change.

To use the Sync Slicers feature, do the following:

  1. Click on the View tab of the ribbon. In the Show section, check the box next to Sync slicers. The Sync Slicers pane appears between the Filters pane and the VISUALIZATIONS pane.
  2. Select the Dates slicer. Note that, at the top, all of the page names in the report are listed. The Visible (eyeball) icon states whether or not the slicer is present on the page. There is also a Sync icon that allows you to check on which pages the slicer is kept in sync.
  3. Expand the Advanced options section.
  4. In the field, type Dates and then note that the box next to Sync field changes to other slicers is checked automatically. This option means that any slicers with this same group name will be kept in sync, regardless of the pages they are on.
  1. Click on the Target Utilization slicer. Since we copied and pasted this slicer from the tmpUtilization page and chose to sync slicers, the tmpUtilization page has both the Sync and the Visible (the eyeball icon) checkboxes checked, as well as the Template page. In the Advanced options, there is an existing group name of Target Utilization.
  2. Click on the Branch slicer and add a group name of Branches.
  3. Click on the Division slicer and add a group name of Divisions.
  4. Click on the Employee Type slicer and add a group name of Employee Types.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.142.171.137