Time Granularity
D/W/M/Q 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:
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
Asks two things — how the axis labels should read, and which grain (D / W / M / Q) is selected when the report opens
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
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
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
Category
Build
Version
Version 3.2.2.2
or log in if you already have an account

