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
| Setting | Type | Default |
|---|---|---|
| License key | Text | (empty) |
| Status | Read-only text | (hidden until a key is entered) |
Only needed for environments AppSource licensing doesn't cover. See Direct license keys.
Calendar
| Setting | Options | Default |
|---|---|---|
| Default View | Month · Week · Day · List · Year · Quarter | Month |
| First Day of Week | Monday · Sunday · Saturday | Monday |
| Enable Month View | On · Off | On |
| Enable Week View | On · Off | On |
| Enable Day View | On · Off | On |
| Enable List View | On · Off | On |
| Enable Year View | On · Off | On |
| Enable Quarter View | On · Off | On |
| End Date Interpretation | Exclusive (iCal) · Inclusive | Exclusive (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:59are always exact.
→ Views & navigation · End Date
Work Hours
| Setting | Options | Default |
|---|---|---|
| Monday – Friday | On · Off | On |
| Saturday, Sunday | On · Off | Off |
| Work Start Hour | 0 – 24 | 9 |
| Work End Hour | 0 – 24 | 18 |
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.
Event Display
| Setting | Options | Default |
|---|---|---|
| Show Time in List View | On · Off | On |
| Max Events Per Cell | 1 – 5 | 3 |
Max Events Per Cell applies to Month and Quarter views; events beyond the cap collapse into a "+N more" button.
Legend
| Setting | Options | Default |
|---|---|---|
| Show Legend | On · Off | On |
| Position | Top · Bottom · Left · Right · Top Center · Bottom Center | Bottom |
| Font Size | 8 – 60 | 11 |
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
| Setting | Options | Default |
|---|---|---|
| Show tooltips | On · Off | Off |
| Show start/end dates | On · Off | On |
| Show category | On · Off | On |
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
| Setting | Options | Default |
|---|---|---|
| Show holidays | On · Off | Off |
| Country or region | United States · United Kingdom · France · Germany · Canada · Australia · Spain · Italy · Netherlands · Belgium | United States |
| Holiday color | Any 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.
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.
Settings that aren't in the pane
Some state belongs to the viewer's session rather than to the report:
| State | Set by | Saved? |
|---|---|---|
| Current view | The view selector | No — resets to Default View on reload |
| Current period | The ‹ › arrows, Today, clicking a day or month | No — reopens on today |
| Selected events | Clicking events or legend items | Captured by bookmarks |
Settings the host overrides
| Mode | What changes |
|---|---|
| High contrast | Event 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 hosts | Selection 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.
Report themes set defaults. Anything an editor changes in the Format pane wins over the theme for that visual.
See also
- Data fields — what to put in each field well.
- Use cases — recommended settings per scenario.
- Troubleshooting — when a setting doesn't do what you expect.