Time Period Slicer

Rolling Periods That Coexist With Your Year Slicer

Build

Build

time-period-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:

  1. 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

  2. Creates a period selector table with period names and sort order

  3. Creates a bridge calculated table that maps each period to its exact date rows using correct month boundaries

  4. Creates a disconnected axis table (monthly, quarterly, weekly, or daily) so the year slicer cannot collapse multi-year periods

  5. 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

  6. Registers all three tables in the model definition

  7. Creates visual filter, date boundary, and wrapper measures in the measure table

  8. Scans existing slicer styles on the target page and creates a styled period tile slicer

  9. 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

  10. 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

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