First steps
First steps
Overview
This guide explains how to add and configure SLICERBAR items, including Slicers, Date Pickers, Buttons, and Groups. You'll learn how to:
Use auto creation to quickly generate items from your dimensions
Manually add and configure each item type
Combine items into a Group for more advanced layouts
Auto creation
SLICERBAR offers an auto-creation option. When enabled, adding a dimension automatically detects which item type should be created and generates it for you.
How it works
Right-click on the extension and confirm that Auto creation is enabled.
Add your dimensions — the appropriate items are created automatically.
Add items manually
Use manual creation when you want full control over which items are added and how they are configured. Ensure Auto creation is disabled before following the steps below.
Add a Slicer
Click the SLICERBAR extension to add it to your sheet.
Add one or more dimensions to your extension.
Click Setup — the settings panel will expand.
Click or drag Slicer from the left-hand panel into the builder area.
Select a dimension, then click Save.
Your Slicer item is now active and ready to use.
Add a Date Picker
Click or drag Date Picker from the left-hand panel into the builder area.
Select a date dimension.
Disable Date hierarchy.
You now have a functional Date Picker.
Add a Button container
Drag a Button container from the left-hand panel into the builder area.
Select the Button container area and update the Label.
Select the Button inside the container and update its Label.
Open Actions for the Button.
Choose Clear All Filters, then click OK.
Your Button container now includes a button that clears all filters when clicked.
Button + Button container demo
Add a Group
Drag a Group from the left-hand panel into the builder area.
Drag a Button container, Date Picker, and Slicer into your Group.
Configure each item individually by selecting it and adjusting its settings:
Button container — set labels and actions
Date Picker — choose the date dimension and toggle hierarchy
Slicer — select a dimension and adjust settings
Your Group now combines multiple controls into a single reusable layout.
Group demo
Preview of changes
Issue | Fix applied |
|---|---|
No intro or context | Added an Overview section explaining what the page covers. |
Concepts and tasks mixed | Separated Auto creation from Add items manually. |
Inconsistent headings | Applied a cleaner H2 → H3 hierarchy throughout. |
Broken numbered lists | Kept each procedure in a clear, linear order while preserving supporting images. |
Inconsistent wording | Standardised action verbs such as Click, Drag, Select, Open, Choose, and Save. |
No outcome statements | Added a clear result sentence at the end of each how-to. |