You can create a Slicer to filter data visually by following these steps:
Click the Add Chart button on the toolbar.
In the Visualizations panel (on the right side of the screen), select a Slicer type from the list of available visualizations.
Drag the data fields you want to filter into the Dimensions area. These fields will become the selectable elements in the slicer.
If you're using a hierarchical structure, make sure to drag the fields in top-down order (e.g., Year → Quarter → Month).
Click the Style icon in the Visualizations panel to customize your slicer. Here, you can rename the slicer or adjust formatting options.
After creating and customizing the slicer, click Save to store your changes.
Last updated 4 months ago
Was this helpful?