Year Range Slicer

Back

CY / 2Y / 3Y Year Window Slicer

Build

Overview

Features

Prompts

Help

Key Features

Your bar chart spans five years of data, but stakeholders usually care about only the current year or the last two. Hiding past years via a static date filter breaks when the calendar rolls over, and building a dynamic year window requires a disconnected parameter table, a filter measure with the right guard logic, a tile slicer with correct interaction rules, and — when the chart axis uses the calendar table — an auto-created disconnected axis table and wrapper measures. This skill builds all of it from a single prompt — run it with /year-range-toggle.

How it works

Type /year-range-toggle, specify the target chart(s) and which periods to include, and the skill handles everything:

Asks which periods to include — CY, 2Y, 3Y, 4Y, or 5Y — before proceeding
Detects the calendar table, year column, and measure table from TMDL automatically
If the chart axis is on the calendar table, auto-creates a disconnected axis table with wrapper measures — no prompt needed
Creates a disconnected parameter table with label and order columns
Writes a visual-level filter measure with a blank-guard so all years show when no external year slicer is active
Creates a tile slicer above the chart, sized and styled to match existing page slicers
Applies the filter measure as a visual-level filter on the target chart
Sets interaction rules so slicer tiles cross-filter only their paired chart

What you get

Disconnected parameter table — with Label (CY, 2Y, ...) and Order columns; one table per target chart when multiple visuals are provided
Filter measure — returns 1 for bars within the selected window, 0 for bars outside; blank-guard shows all years when no external year slicer is selected
Updated chart visual — filter measure wired as a visual-level filter; axis updated to the disconnected table when auto-created
Wrapper measures — created when the axis table is auto-created from the calendar table
Tile slicer — positioned directly above the chart, right-aligned, styled to match the page; one slicer per target chart
Scoped interactions — slicer tiles filter only their paired chart; other page visuals are unaffected

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