Skip to main content

Formatting reference

Every setting in the Calendar's Format pane (the paint-roller icon), card by card, with its range and default. For task-based walkthroughs, follow the links at the end of each section.

License

SettingTypeDefault
License keyText(empty)
StatusRead-only text(hidden until a key is entered)

Only needed for environments AppSource licensing doesn't cover. See Direct license keys.

Calendar

SettingOptionsDefault
Default ViewMonth · Week · Day · List · Year · QuarterMonth
First Day of WeekMonday · Sunday · SaturdayMonday
Enable Month ViewOn · OffOn
Enable Week ViewOn · OffOn
Enable Day ViewOn · OffOn
Enable List ViewOn · OffOn
Enable Year ViewOn · OffOn
Enable Quarter ViewOn · OffOn
End Date InterpretationExclusive (iCal) · InclusiveExclusive (iCal)
  • The Default View stays available even if its own Enable toggle is off.
  • Changing Default View also resets any view a viewer had switched to.
  • End Date Interpretation applies only to date-only end values; timed events and ends written as 23:59 are always exact.

Views & navigation · End Date

Work Hours

SettingOptionsDefault
MondayFridayOn · OffOn
Saturday, SundayOn · OffOff
Work Start Hour0 – 249
Work End Hour0 – 2418

Presentation only — nothing is hidden or filtered. Non-working days and hours are shaded in Week view, non-working hours in Day view, and both views open scrolled to the middle of the working day. Month, Quarter, Year and List views are unaffected.

Working hours

Event Display

SettingOptionsDefault
Show Time in List ViewOn · OffOn
Max Events Per Cell1 – 53

Max Events Per Cell applies to Month and Quarter views; events beyond the cap collapse into a "+N more" button.

Event density

Legend

SettingOptionsDefault
Show LegendOn · OffOn
PositionTop · Bottom · Left · Right · Top Center · Bottom CenterBottom
Font Size8 – 6011

The legend appears only when a Category field is bound and at least one event has a category. It takes its space from the grid, and its items are clickable filters.

The legend · Filtering from the legend

Tooltips

SettingOptionsDefault
Show tooltipsOn · OffOff
Show start/end datesOn · OffOn
Show categoryOn · OffOn

Hover tooltips are off by default. Show tooltips also gates report-page tooltips — with it off, neither kind appears. The details popover shown on click is unaffected.

Tooltips

Holidays

SettingOptionsDefault
Show holidaysOn · OffOff
Country or regionUnited States · United Kingdom · France · Germany · Canada · Australia · Spain · Italy · Netherlands · BelgiumUnited States
Holiday colorAny colour#7B68A6

National/federal holidays only — no regional holidays and no weekend-to-Monday shifting. Holidays are inert: they can't be selected, cross-filtered, or shown in the legend.

Public holidays

Data Colors

One colour picker per distinct value in the Category field, labelled with the value.

  • Defaults come from the report theme palette.
  • Categories take their slot alphabetically, so a category keeps its colour across refreshes.
  • Up to 20 categories get a picker; beyond that they're still coloured from the theme palette, without a swatch.
  • The card only appears when the Category field is bound.

Categories & colours

Settings that aren't in the pane

Some state belongs to the viewer's session rather than to the report:

StateSet bySaved?
Current viewThe view selectorNo — resets to Default View on reload
Current periodThe ‹ › arrows, Today, clicking a day or monthNo — reopens on today
Selected eventsClicking events or legend itemsCaptured by bookmarks

What is and isn't saved

Settings the host overrides

ModeWhat changes
High contrastEvent chips become outlined, and every colour — including Data Colors and the holiday colour — is taken from the Windows system palette. Your settings are kept and return when high contrast is switched off.
Dashboard tiles / read-only hostsSelection and cross-filtering are disabled by Power BI. Tooltips and rendering are unaffected.

Setting the Calendar from a report theme

All of these settings can be set in a report theme JSON file, which is the practical way to standardize many reports — or to deploy a direct license key across a tenant. Use the visual's GUID as the key:

{
"name": "Calendar defaults",
"visualStyles": {
"CalendarVisualb7f3c2a1d4e5f6a7b8c9d0e1f2a3b4c5": {
"*": {
"calendarSettings": [
{
"defaultView": "month",
"firstDayOfWeek": "1",
"endDateInterpretation": "inclusive",
"enableYearView": false
}
],
"workSettings": [{ "workStartHour": 8, "workEndHour": 17 }],
"eventDisplay": [{ "maxEventsPerCell": 4 }],
"legend": [{ "show": true, "position": "Top", "fontSize": 12 }],
"tooltipSettings": [{ "show": true }],
"holidaySettings": [
{ "show": true, "region": "GB", "holidayColor": { "solid": { "color": "#7B68A6" } } }
]
}
}
}
}

Values match the pane options exactly: views are month, week, day, list, year, quarter; firstDayOfWeek is "1" (Monday), "0" (Sunday) or "6" (Saturday); regions are the two-letter codes US, GB, FR, DE, CA, AU, ES, IT, NL, BE.

note

Report themes set defaults. Anything an editor changes in the Format pane wins over the theme for that visual.

See also