Time Period Slicer + Custom

Period Tiles + Custom Date Range Picker

Build

Build

time-period-slicer-custom

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:

  1. Reads your model — auto-detects the calendar, its date/year columns, the fact tables, the measure table, and the visuals on the page

  2. 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)

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

  4. 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)

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

  6. Adds the two slicers — a period tile slicer and a date-range picker, styled to match your page

  7. Wires each target chart — axis swapped to the disconnected table, wrapper measures on the values, the period filter applied, and the dynamic title bound

  8. Keeps interactions clean — the slicers only affect the charts you targeted

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

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