Time Period Slicer + Custom
Period Tiles + Custom Date Range Picker
Overview
Features
Prompts
Help
Key Features
Give users both — quick rolling-period buttons (L2W…L5Y) and a Custom option that opens a free date-range picker — on the same chart, working alongside your year slicer.
Sometimes preset period buttons aren't enough — someone wants an exact from/to window. This skill gives you both on one chart: the rolling-period tiles and a Custom option that switches on a date-range slicer. Getting that pair to behave next to a year slicer is the hard part — a bidirectional bridge collapses the calendar the moment a year is picked, and putting calendar columns on the axis breaks cross-year periods. The skill builds the whole thing correctly — the tables, the single-direction bridge, the disconnected axis, the wrapper measures, a dynamic title, and the two styled slicers — auto-detecting your calendar, fact tables, and measures — run it with /time-period-slicer-custom.
How it works
Type /time-period-slicer-custom, point it at the chart (or charts) to filter, confirm two things, and the skill builds everything:
Reads your model — auto-detects the calendar, its date/year columns, the fact tables, the measure table, and the visuals on the page
Asks two things — which rolling periods to include (all 8 by default; a Custom option is always added) and the axis granularity (monthly, quarterly, weekly, or daily)
Builds the tables — a period selector, a bridge, a disconnected date-range table for the picker, and a disconnected axis table the year slicer can't restrict
Wires the relationships — bridge-to-period and a single-direction bridge-to-calendar (no bidirectional, which is what stops the year slicer collapsing the calendar)
Writes the measures — the period filter, the rolling-window wrappers per measure, a "disable" helper for greying out the date slicer, and a dynamic title that names the active window
Adds the two slicers — a period tile slicer and a date-range picker, styled to match your page
Wires each target chart — axis swapped to the disconnected table, wrapper measures on the values, the period filter applied, and the dynamic title bound
Keeps interactions clean — the slicers only affect the charts you targeted
Keeps working under bookmarks — the period filter is re-asserted on any target chart captured in a bookmark, so navigation doesn't drop it
What you get
A period tile slicer + a date-range picker — the preset buttons plus a Custom option that switches on the free date range, both styled to match your page
Four supporting tables — period selector, bridge, custom date-range table, and disconnected axis
DAX measures — the period filter, per-measure rolling-window wrappers, a date-slicer "disable" helper, and a dynamic title
A self-updating title — names the active window, e.g. "L3M (Oct 2014 – Dec 2014)"
Wired target charts — axis swapped, wrapper measures on the values, filter and title applied
Bookmark-safe wiring — the period filter is re-asserted on captured target charts so bookmark navigation doesn't drop it
Explore more in this category

Absolute / Percentage Toggle
Build
Add a tile slicer to any chart that switches between absolute values and percentages

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)
249 USD
Category
Build
Version
Version 3.2.2.2.6
or log in if you already have an account

