22.7 Slicers: Styles and Settings
Steps in Power BI – City slicer
- Click an empty canvas area › Visualizations › Slicer.
- Drag
DarkStore[City]into Field. - Format visual › Visual › Slicer settings › Options › Style: Vertical list, Tile or Dropdown.
- Slicer settings › Selection: Single select On/Off; Multi-select with CTRL On/Off; Show "Select all" option On/Off.
- Slicer header (title text, font), Values (font, background), Items or Buttons formatting, and a Search option (… › Search) for long lists.
| Style | Field type | Best use | Quick-commerce example |
|---|---|---|---|
| Vertical list | Text/any | Few values, always visible | Platform (Blinkit, Amazon Now) |
| Tile (buttons) | Text | 2–6 values, touch-friendly | City tiles: Pune, Solapur, Nashik … |
| Dropdown | Any | Many values, saves space | Store Name, Product Name |
| Between (range) | Number / date | Numeric or date range with slider | Delivery Time Mins 0–30; Order Date range |
| Less than or equal to / Greater than or equal to | Number | One-sided limit | Amount ≥ ₹500 |
| Before / After / List / Dropdown | Date | Date choices | Orders after 01-10-2025 |
| Relative Date | Date | Last N days/weeks/months | Last 7 days |
| Relative Time | Date/time | Last N minutes/hours | Last 3 hours of orders |
| Hierarchy slicer | Several fields or a hierarchy | Drill in the slicer | Maharashtra › Pune › Kothrud (Module 12.4) |
| Button slicer (newer) | Any | Modern tabs/cards with images, states and layouts | Metric Selector tabs, Platform buttons with logos |
| List slicer (newer) | Any | Richer list formatting and hierarchy support | Category › Sub Category |
Tip
For a date range, use the Between style on 'Date'[Date] (from the Date table, not Orders), so the slicer filters all related facts and time intelligence keeps working.
Ravindra Bagale's Tip
Ek common chuk mhanje showing a slicer with hundreds of values (Customer Name) as a list. Use a dropdown with search, or a hierarchy slicer. Choose single select or multi-select deliberately, and turn on "Select all" only when it makes sense. Samjla ka?