Time Period Selector + Custom
Pre-Filter Date Performance
Build
Overview
Features
Prompts
Troubleshooting
Key Features
Period tiles (L2W, L1M, L3M) plus a custom date range picker — the common DAX approach forces a double SUMMARIZECOLUMNS pass. The performant approach uses a bridge table with a bidirectional relationship to pre-filter the calendar physically, but building it correctly involves a bridge calculated table, a disconnected DateSelector, two relationships, and careful circular dependency avoidance. This skill builds the entire infrastructure — tables, relationships, measures, and slicers — and wires your visuals in one session.
How it works
Type /time-period-bridge-slicer, configure your periods and calendar table, and the skill builds the full infrastructure:
Creates a period DATATABLE (Hlp_TimePeriodSelector) with your selected periods
Creates a bridge calculated table that maps each period to its date range using CALENDAR()
Creates a disconnected DateSelector table for custom date range picking
Adds two relationships — standard M:1 for period, bidirectional M:1 for dates
Creates DAX measures for filtering, slicer disabling, and date display
Creates two slicer visuals — period tile and date range picker
Wires target visuals with visual-level filters or
_TPsuffix measures
What you get
3 new tables — period selector, bridge, and DateSelector
2 relationships — including the critical bidirectional bridge-to-calendar link
DAX measures —
_TimePeriod_Filter,_Timeline Slicer Disable, optional min/max dates2 slicer visuals — period tiles and date range picker
Wired target visuals — with visual-level filters or
_TPwrapper measures
Explore more in this category
Absolute / Percentage Toggle
Build
Add a two-button tile slicer to any chart that switches between absolute values and a percentage variant, with a dynamic format string and auto-derived chart title.
Active Filters Card Visual
Build
Generate a card visual that dynamically displays all currently active slicer and filter selections.
Clone Page
Build
Clone any report page with all visuals, bookmark navigators, interactions, and drillthrough bindings as a fully independent copy.
Convert to Trendline
Build
Add formatted data labels, markers, area shading, and a canvas tooltip to line chart visuals.