Select one slicer, then hold down the Control key and select another. You can set options for more than one slicer at the same time. If I remove the option to visually indicate empty items altogether, all department buttons remain in the same location and look the same, whether they contain data or not.įinally, if I enable the option to hide empty buttons, departments without data disappear altogether. If I uncheck the option to show empty items last, the empty departments still have a different color, but they no longer move around. Notice departments with no data appear in a different color and are shifted to the bottom of the list. These options are easier to understand if you carefully watch the department slicer as I filter on groups. The Slicer Settings window also contains various options for handling values that no longer exist in filtered data.īy default, a slicer will show items that don't contain data, and also reorder these buttons to appear last in the list. Just make sure the option is enabled in the Slicer Settings dialog. There's even a setting to sort buttons using custom lists. If you want to hide the caption, uncheck the "display header" option.īy default, slicer buttons are sorted A-Z, but you can also sort buttons in descending order. You can set the heading or caption for a slicer directly on the ribbon itself.
You can access these same settings by right-clicking on a slicer. The slicer settings button opens a window with more settings. The Slicer Tools ribbon will appear whenever you select a slicer. Options appear grouped in 5 main categories To access these settings, select a slicer and click "Options" under the Slicer Tools menu in the ribbon. Table slicers have a variety of settings. In this video, we'll look at the options available in Table slicers.
0 kommentar(er)
