Date Slicer fields and settings

Every field well and every setting in the format pane of version 1.0.1.0, read from the package you download. The internal names in grey are what a PBIR file or a report-authoring agent uses. Which features need a licence is on the Date Slicer page; every setting works in edit mode with or without one.

4 fields · 8 cards · 75 settings Markdown for AI assistants catalog.json

Fields

Field	Takes	Needed	What it is for
Date`date`	Column	Optional · up to 4	The date column to filter. Use your date table's Date column for the best results; the auto date hierarchy works too.
Data density (optional)`value`	Measure	Optional	A measure drawn as bars under the timeline and used for the 'latest date with data' anchor. Power BI syncs slicers across pages only when the slicer has a single field.
Comparison date (optional)`compareDate`	Measure	Optional	A date column (usually a disconnected comparison calendar) that receives the comparison period. Premium. Disables sync slicers.
Tooltips`tooltips`	Measure	Optional · up to 5	Extra measures shown when hovering a day or period.

Layout`layout`

Setting	Type and options
Layout`mode`	Auto (fit the space) `auto` Calendar `calendar` Timeline `timeline` Compact bar `compact` Presets list `list`
Months shown`months`	Auto `auto` 1 2 3
Selection`selectionType`	Between `range` Single day `single` On or after `after` On or before `before`
Timeline granularity`granularity`	Day `day` Week `week` Month `month` Quarter `quarter` Half-year `half` Year `year`
Granularity switch`showGranularity`	On / off
Typed date entry`showInputs`	On / off
Previous / next arrows`showStepper`	On / off
Apply button`applyButton`	On / off

Presets`presets`

Setting	Type and options
Show presets`show`	On / off
Position`position`	Auto `auto` Side `side` Top `top`
Today / Yesterday`days`	On / off
This week / month / quarter / year`thisPeriods`	On / off
Last week / month / quarter / year`lastPeriods`	On / off
Next week / month / quarter`nextPeriods`	On / off
Last 7 / 30 / 90 / 365 days`rolling`	On / off
Last 12 months (rolling and full months)`rolling12`	On / off
Week / month / quarter / year to date`toDate`	On / off
Half-years (this, last, to date)`halfYears`	On / off
Last 20 working days (premium)`workingDays`	On / off
Let viewers choose Last / Next N`viewerCustom`	On / off
Group headings`showGroups`	On / off
Custom preset`custom`	On / off
Custom: how many`customCount`	Number
Custom: unit`customUnit`	Days `day` Weeks `week` Months `month` Quarters `quarter` Half-years `half` Years `year`
Custom: include current`customCurrent`	On / off

Default and reset`selection`

Setting	Type and options
Default selection`defaultPreset`	None (all dates) `none` Today `today` Yesterday `yesterday` This week `thisWeek` This month `thisMonth` This quarter `thisQuarter` This year `thisYear` Last week `lastWeek` Last month `lastMonth` Last quarter `lastQuarter` Last year `lastYear` Last 7 days `last7` Last 30 days `last30` Last 90 days `last90` Last 12 months `last12m` Week to date `wtd` Month to date `mtd` Quarter to date `qtd` Half-year to date `hytd` Year to date `ytd` Last 12 full months `last12cm` Custom preset `custom`
Relative presets follow the calendar`rolling`	On / off
Presets end on`anchor`	Today `today` Yesterday (complete days) `yesterday` Latest date with data `latest`
Reset button`resetButton`	On / off
Clear button`clearButton`	On / off

Calendar`calendar`

Setting	Type and options
Week starts on`weekStart`	Monday `1` Sunday `0` Saturday `6`
Week numbers`weekNumbers`	Off `none` ISO 8601 `iso` Week of 1 January = 1 `simple`
Year type`yearMode`	Calendar year `calendar` Fiscal year `fiscal` Retail 4-4-5 year (premium) `retail`
Fiscal year starts`fiscalStart`	January `0` February `1` March `2` April `3` May `4` June `5` July `6` August `7` September `8` October `9` November `10` December `11`
Fiscal year name`fiscalNaming`	By end year `end` By start year `start`
Retail pattern`retailPattern`	4-4-5 `445` 4-5-4 `454` 5-4-4 `544`
Retail year ends in`retailEndMonth`	January `0` February `1` March `2` April `3` May `4` June `5` July `6` August `7` September `8` October `9` November `10` December `11`
Retail year ends on`retailEndWeekday`	Sunday `0` Monday `1` Tuesday `2` Wednesday `3` Thursday `4` Friday `5` Saturday `6`
Retail year-end rule`retailRule`	Weekday nearest month end `nearest` Last weekday of month `last`
Public holidays`holidays`	None `none` United States (federal) `us` United Kingdom (England & Wales) `uk` Germany (national) `de` France `fr` Czechia `cz` Poland `pl` Austria `at` Netherlands `nl` Spain (national) `es` Italy `it` Canada (federal) `ca` Australia (national) `au` Slovakia `sk` Hungary `hu` Belgium `be` Ireland `ie` Portugal `pt` Sweden `se` Denmark `dk` Norway `no` Finland `fi`
Weekend`weekend`	Saturday and Sunday `satSun` Friday and Saturday `friSat` Sunday only `sun` No weekend `none`
Shade weekends`shadeWeekends`	On / off

Period intelligence (premium)`intelligence`

Setting	Type and options
Comparison period`comparison`	Off `none` Previous period `previous` Same period last year `sply` 52 weeks back (same weekdays) `sply52`
Show comparison in header`showComparison`	On / off
Filter working days only`workingDaysOnly`	On / off

Header`header`

Setting	Type and options
Show header`show`	On / off
Preset name`showLabel`	On / off
Day count`showDays`	On / off
Data through date`showDataThrough`	On / off
Date format`dateFormat`	Medium (27 Sep 2026) `medium` Short (27/09/2026) `short` Long (27 September 2026) `long` ISO (2026-09-27) `iso`
Text size`fontSize`	Number
Text colour`fontColor`	Colour

Theme and colours`style`

Setting	Type and options
Theme`theme`	SmartVisuals `smartvisuals` Dark `dark` Clean `clean` Slate `slate`
Font`fontFamily`	Theme default `theme` Inter `inter` Segoe UI `segoe` Arial `arial` Georgia `georgia`
Text size`fontSize`	Number
Text colour`fontColor`	Colour
Background`background`	Colour
Headings (months, groups, captions)`headingColor`	Colour
Secondary text (weekdays, week numbers)`mutedColor`	Colour
Preset button colour`chipColor`	Colour
Preset button text`chipTextColor`	Colour
Lines and borders`borderColor`	Colour
Dates without data`noDataColor`	Colour
Selection colour`accent`	Colour
Range colour`rangeColor`	Colour
Today marker`todayColor`	Colour
Holiday marker`holidayColor`	Colour
Weekend shading`weekendColor`	Colour
Data density bars`densityColor`	Colour
Comparison colour`compareColor`	Colour
Transparent background`transparent`	On / off

Accessibility`accessibility`

Setting	Type and options
Focus outline colour`focusColor`	Colour
Focus outline width (px)`focusWidth`	Number
Minimum text size (px, 0 = off)`minFontSize`	Number
Strike through dates without data`noDataCue`	On / off

Setting a value in PBIR

In a visual.json, a setting goes under visual.objects, by card and internal name. Toggles take true or false, choices and text a value in single quotes ('auto'), numbers a D suffix (12D).

"visual": {
  "visualType": "dateSlicer5B31A308CE89423F868B26BA14DFA05F",
  "objects": {
    "layout": [{
      "properties": {
        "showGranularity": { "expr": { "Literal": { "Value": "true" } } }
      }
    }]
  }
}

Date Slicer fields and settings

Fields

Layoutlayout

Presetspresets

Default and resetselection

Calendarcalendar

Period intelligence (premium)intelligence

Headerheader

Theme and coloursstyle

Accessibilityaccessibility