Time Period Slicer + Custom

Period Tiles + Custom Date Range Picker

Build

Build

time-period-slicer-custom

Overview

Features

Prompts

Help

Key Features

Period tile buttons and a custom date range picker sound straightforward, but making them work correctly alongside a year slicer requires careful architecture. Bidirectional bridge relationships collapse the calendar when a year is selected. Using calendar table columns on the chart axis prevents cross-year periods from displaying. Cards and matrices need a different pattern than date-axis charts. This skill builds the entire infrastructure correctly — 4 tables, 2 relationships, wrapper measures, theme-sized slicers, and scoped interactions — auto-detecting your calendar, fact table, and target measures with no manual configuration — run it with /time-period-slicer-custom.

How it works

Type /time-period-slicer-custom, specify your report, page, and target visual(s), and the skill scans the model and asks two questions:

  1. Which periods? (default: all 8 — L2W L1M L3M L6M L1Y L2Y L3Y L5Y; Custom always added)

  2. What granularity? (monthly / quarterly / weekly / daily)

It then builds the complete infrastructure:

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

  2. Creates a bridge table that maps each period to its date range

  3. Creates a disconnected table for the custom date range slicer

  4. Creates a disconnected axis table (year x period-unit grid) so the year slicer cannot restrict its rows

  5. Adds 2 relationships — bridge to period selector and single-direction bridge to calendar (no bidirectional)

  6. Inserts period filter, timeline disable, and wrapper measures

  7. Creates a period tile slicer and a date range slicer

  8. Wires target visuals — axis swapped to disconnected axis table, measures replaced with wrapper variants, period filter applied

  9. Wires scoped interactions so the slicers don't filter non-target visuals

What you get

  • 4 new tables — period selector, bridge, custom date range, and disconnected axis table

  • 2 relationships — single-direction bridge-to-calendar (prevents year slicer collapse)

  • DAX measures — period filter, timeline disable, and wrapper measures per target visual measure

  • 2 slicer visuals — period tile slicer and date range picker

  • Wired target visuals — axis swapped to disconnected table, wrapper measures on value axis, filter applied

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