Time Granularity

D/W/M/Q slicer

Build

Build

time-granularity-slicer

Overview

Features

Prompts

Help

Key Features

Your line chart shows monthly revenue, and someone asks to see it weekly, or daily, or rolled up to quarters. The clean way to do this in Power BI is a field parameter that swaps the axis column on the fly — one chart, four views, and your existing measures keep working untouched. But wiring it up by hand is the kind of job that eats an afternoon: you need new calendar columns for each grain, a hidden column to keep each one sorted in calendar order, the field parameter itself, a slicer styled to match the page, and the chart pointed at it correctly. Miss one piece and the axis sorts alphabetically or the slicer does nothing.

This skill builds the whole thing in one pass. Point it at your chart, answer two quick questions, and you get a working granularity slicer — run it with /time-granularity-slicer.

How it works

Type /time-granularity-slicer, point it at your chart, answer two questions, and the skill does the rest:

  1. Looks at your model — finds your calendar table (whether it comes from Power Query or a DAX table), the chart's position, and the look of your existing slicers

  2. Asks two things — how the axis labels should read, and which grain (D / W / M / Q) is selected when the report opens

  3. Builds it — adds the calendar columns it needs, creates the field parameter, drops a tile slicer onto the page, and points the chart's X-axis at it

  4. Checks its own work — confirms every piece is in place before handing back

If your calendar comes from Power Query, the skill quietly adds a small helper table instead of touching the calendar — you don't have to do anything different.

Three layout options

Option

X-Axis

Labels

Best for

1. Year hierarchy

Year > Granularity

Short (Jan, Q1, W5)

Dashboards that compare across years

2. Year in labels

Granularity only

Full (Jan 2025, Q1 2025)

Standalone charts spanning several years

3. Date columns

Date-type axis

Raw dates (1/1/2025)

Continuous axes with no scroll bar

What you get

  • D / W / M / Q tile slicer — styled to match the slicers already on your page, with your chosen grain selected on open

  • One chart, four views — the X-axis swaps between daily, weekly, monthly, and quarterly when a tile is clicked

  • A self-updating subtitle — the chart subtitle shows the current grain in words ("Month", "Week", …) so the view is never ambiguous; your title is left alone

  • Calendar columns that sort correctly — each grain stays in true calendar order, never alphabetical

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD

Category

Build

Version

Version 3.2.2.2

or log in if you already have an account