Time Period Slicer + Custom
Period Tiles + Custom Date Range Picker
Overview
Features
Prompts
Help
Key Features
Period tile buttons and a custom date range picker sound straightforward, but making them work correctly alongside a year slicer requires careful architecture. Bidirectional bridge relationships collapse the calendar when a year is selected. Using calendar table columns on the chart axis prevents cross-year periods from displaying. Cards and matrices need a different pattern than date-axis charts. This skill builds the entire infrastructure correctly — 4 tables, 2 relationships, wrapper measures, theme-sized slicers, and scoped interactions — auto-detecting your calendar, fact table, and target measures with no manual configuration — run it with /time-period-slicer-custom.
How it works
Type /time-period-slicer-custom, specify your report, page, and target visual(s), and the skill scans the model and asks two questions:
Which periods? (default: all 8 — L2W L1M L3M L6M L1Y L2Y L3Y L5Y; Custom always added)
What granularity? (monthly / quarterly / weekly / daily)
It then builds the complete infrastructure:
Creates a period selector table with period names and sort order
Creates a bridge table that maps each period to its date range
Creates a disconnected table for the custom date range slicer
Creates a disconnected axis table (year x period-unit grid) so the year slicer cannot restrict its rows
Adds 2 relationships — bridge to period selector and single-direction bridge to calendar (no bidirectional)
Inserts period filter, timeline disable, and wrapper measures
Creates a period tile slicer and a date range slicer
Wires target visuals — axis swapped to disconnected axis table, measures replaced with wrapper variants, period filter applied
Wires scoped interactions so the slicers don't filter non-target visuals
What you get
4 new tables — period selector, bridge, custom date range, and disconnected axis table
2 relationships — single-direction bridge-to-calendar (prevents year slicer collapse)
DAX measures — period filter, timeline disable, and wrapper measures per target visual measure
2 slicer visuals — period tile slicer and date range picker
Wired target visuals — axis swapped to disconnected table, wrapper measures on value axis, filter applied
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.

Apply rounded
Build
Convert standard column or bar charts to a lollipop "rounded column" style using Power BI's native error bar feature

Clone Page
Build
Clone any report page with all visuals and bookmarks
Tool Information
Skill
39 USD
Bundle (All skills)
129 USD
Category
Build
Version
Version 2.1.1.2.15
or log in if you already have an account

