Time Period Slicer

Rolling Periods That Coexist With Your Year Slicer

Build

Build

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

  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: bridge-to-period and bridge-to-calendar — no bidirectional filtering, which is what stops the year slicer 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 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

  10. Writes scoped interaction entries so the slicer only affects its target visuals

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

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