A clickable button panel that filters a pivot table or table visually.
Try it with AIA slicer is an on-sheet control with buttons for each value in a field. Clicking buttons filters the connected pivot table or Excel table instantly, and one slicer can control several pivots at once.
A slicer is a visible, clickable filter that shows the current selection at a glance.