Time Period Slicer
Rolling Periods That Coexist With Your Year Slicer
Overview
Features
Prompts
Help
Key Features
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 isolates period filtering from the year slicer — run it with /time-period-slicer.
How it works
Type /time-period-slicer, 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: standard bridge-to-period and bridge-to-calendar — no bidirectional filtering, which is what prevents the year slicer from 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 target visuals: swaps the category axis to the disconnected axis table, applies a visual-level filter, and replaces base measures with their wrapper variants
Optionally writes scoped interaction entries so the slicer only affects the target visuals
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 — horizontal button slicer styled to match existing page slicers
Updated target visuals — category axis swapped, visual filter applied, wrapper measures wired
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

