~/talk

Demystifying Power BI Slicers and filters

Talkat SQLBits 2023 · 2023-03-14..03-18· [data-visualization]
links:none on file
slides:none on file

Claim: slicer is a visual and filter is a functionality — slicers render as categorical, date or hierarchical visuals with formatting, relative-date sliders, sync groups and user-changeable sort, while filters live in the filter pane as manual (visual/page/report) or automatic filters, plus include/exclude, drilldown, drillthrough, URL and Q&A pass-through filters. DAX generated is broadly the same so performance rarely differs now; use slicers for layout, multi-field or synced-page interactions and richer formatting, use filter pane to save space, enforce top-N or hide model fixes from end users.

AI-written summary · about

  1. 0:00Start
  2. 1:49Slicers
  3. 6:02Manual Filters
  4. 6:19Automatic Filters
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.