22.8 Clearing Selections
Start with a problem
A manager selected three slicers and cannot find how to clear them.
Explain simply
Clear a slicer with the eraser icon in its header; clear all with a reset bookmark (19.5) or Reset to default in the Service.
Show the data
| Slicer | Selection | Card |
|---|---|---|
| City | Pune | |
| Platform | Blinkit | ₹650 |
About this data: This table uses columns: Slicer, Selection, Card. This table uses columns: Step, Card. This table uses columns: Wrong result, Reason, Correction. Values shown are the lesson examples already on this page (not a new dataset).
Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).
Demonstrate
- Turn on the slicer header (Format › Slicer header On).
- Hover the City slicer › click the eraser.
- Card changes to Blinkit only.
- Clear Platform too.
Show the result
Your result should look like this (fictional sample):
| Step | Card |
|---|---|
| Pune + Blinkit | ₹650 |
| Clear City | ₹1,100 |
| Clear Platform | ₹2,100 |
Explain what happened
Each clear removes that slicer's filter; the card re-evaluates.
Explore further
- Ctrl + click a selected item to deselect it.
Detailed reference for this lesson:
- Eraser icon (Clear selections) in the slicer header clears that slicer (turn the header on to show it).
- Ctrl + click a selected item to unselect it.
- A Clear all slicers button (Insert › Buttons › Blank › Action Clear all slicers) clears all slicers on the page.
- A Reset bookmark button returns everything, including Filters pane filters, to a saved state (Module 19.5).
Ravindra Bagale's Tip
Friends, many students forget to give users a clear way to remove all their selections. Add a Clear selections option in the slicer header or a Reset button (Module 19.5), and test it on every page. Don't make this mistake!
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students users ना त्यांची सगळी selections काढण्याचा स्पष्ट मार्ग द्यायला विसरतात. Slicer header मध्ये Clear selections option किंवा Reset button (Module 19.5) जोडा, आणि प्रत्येक page वर test करा. ही चूक करू नका!
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students users को उनकी सारी selections हटाने का साफ़ तरीका देना भूल जाते हैं. Slicer header में Clear selections option या Reset button (Module 19.5) जोड़ो, और हर page पर test करो. यह गलती मत करना!
Fix common mistakes
| Wrong result | Reason | Correction |
|---|---|---|
| No eraser visible | Header off | Turn on the header |
| Reset brings back old filters | Report saved with selections | Clear before saving |
| Users unsure what is selected | No selection text | Show selection in a text box |
Practise independently
Practice task
Clear only Platform from Pune + Blinkit.
Hints
- Pune total.
Solution
₹850.
Think like a professional
Clear, visible reset options build trust with non-technical users.
Revision card