pbir-filterslisted

Use when authoring filter bodies in a Power BI PBIR report at report.json, page.json, or visual.json filterConfig.filters. Covers scopes (Report, Page, Visual — visual filter is sibling of `visual` NOT nested), filter types (Categorical, Advanced, TopN, VisualTopN, RelativeDate, RelativeTime, Tuple), filter body shape (Version 2, From[] aliases, Where[] using SourceRef.Source NEVER Entity), Categorical In / inverted Not-In with isInvertedSelectionMode, empty-default forms, Advanced Comparison with ComparisonKind 0-4, Between inclusive ranges, RelativeDate DateSpan/DateAdd with TimeUnit codes, TopN VisualTopN, And/Or/Not, doubled single quotes for strings, integer L / double D / datetime literal suffixes, hide/lock/single-select, filter-pane visible+expanded at report level (styling lives in theme). Invoke when user adds a filter, fixes a silently-ignored filter, builds a rolling-date window, or toggles filter-pane visibility.
wardawgmalvicious/claude-config · ★ 1 · Data & Documents · score 75

Install: claude install-skill wardawgmalvicious/claude-config

## PBIR Filters Reference ### Filter Scopes | Scope | Location | Applies To | |---|---|---| | Report | `report.json` → `filterConfig.filters[]` | All pages and visuals | | Page | `page.json` → `filterConfig.filters[]` | All visuals on the page | | Visual | `visual.json` → `filterConfig.filters[]` | That visual only (sibling of `visual`, not nested) | ### Filter Types | `type` | Description | Use Case | |---|---|---| | `Categorical` | In / NotIn list | Year, category, brand (most common) | | `Advanced` | Comparison on measures or columns | Measure > threshold, ranges | | `TopN` | Top/bottom N by measure | Top 10 customers | | `VisualTopN` | Visual-level TopN | Auto-applied by some visuals | | `RelativeDate` | Rolling date window | Last N days/months/years | | `RelativeTime` | Rolling time window | Last N hours/minutes | | `Tuple` | Multi-column composite | Rare | ### Filter Object Properties | Property | Type | Notes | |---|---|---| | `name` | string | 20-char hex unique ID | | `displayName` | string | Optional pane label | | `field` | object | Column or Measure reference (query projection syntax) | | `type` | string | See table above | | `filter` | object | Where clause — optional when no defaults | | `isHiddenInViewMode` | boolean | Hide from pane in reading view | | `isLockedInViewMode` | boolean | Visible but not editable | | `howCreated` | string | `"User"` for user-created | | `ordinal` | integer | Display order (optional) | | `objects` | object | `requireSingleSel