Time Period Slicer
Rolling Periods That Coexist With Your Year Slicer
Overview
Features
Prompts
Help
Key Features
Create a period tile slicer with up to 8 rolling periods (L2W, L1M, L3M, L6M, L1Y, L2Y, L3Y, L5Y) that works correctly alongside year slicers and other calendar slicers on the same page — driving one chart or several from a single slicer.
Period buttons are one of the most requested Power BI features — but building them correctly alongside a year slicer is harder than it looks. A naive bridge relationship lets the year slicer collapse multi-year periods down to a single year, so L2Y with Year=2014 shows only 2014 instead of 2013–2014. This skill uses a disconnected axis table and wrapper measures instead, which keeps period filtering completely separate from the year slicer — run it with `/time-period-slicer`.
How it works
Type /time-period-slicer, point it at the chart (or charts) to filter, confirm which periods to include, and the skill builds everything:
Scans your model and shows you what was auto-detected — calendar table, date column, fact table, measure table, and visuals on the target page — asks only what it can't derive
Creates a period selector table with period names and sort order
Creates a bridge calculated table that maps each period to its exact date rows using correct month boundaries
Creates a disconnected axis table (monthly, quarterly, weekly, or daily) so the year slicer cannot collapse multi-year periods
Adds two relationships: bridge-to-period and bridge-to-calendar — no bidirectional filtering, which is what stops the year slicer propagating into the bridge
Registers all three tables in the model definition
Creates visual filter, date boundary, and wrapper measures in the measure table
Scans existing slicer styles on the target page and creates a styled period tile slicer
Updates each target visual: swaps the category axis to the disconnected axis table, applies a visual-level filter, and replaces base measures with their wrapper variants
Writes scoped interaction entries so the slicer only affects its target visuals
Keeps it working under bookmarks — if a target chart is captured in a bookmark, the period filter is re-asserted so firing the bookmark doesn't drop it, and a drilled-up axis is re-expanded
What you get
Period selector table — up to 8 predefined periods (L2W, L1M, L3M, L6M, L1Y, L2Y, L3Y, L5Y)
Bridge table — maps periods to date rows with correct month boundaries and no bidirectional filtering
Disconnected axis table — monthly, quarterly, weekly, or daily — isolated from the year slicer
Two relationships — bridge to period selector and bridge to calendar (no bidirectional)
DAX measures — visual filter, date boundaries, and wrapper measures for each target measure
Period tile slicer — one horizontal button slicer, styled to match your page, driving all the charts you targeted
Updated target visuals — category axis swapped, visual filter applied, wrapper measures wired
Bookmark-safe wiring — the period filter is re-asserted on any target chart captured in a bookmark, so 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 4.2.2.2.6.2
or log in if you already have an account

