Calendar Slicer Settings

You can manage the calendar slicer's settings to change the year start date, the week start day, and display options in the slicer. To customize the calendar slicer's settings, opening its settings dialog.

Advanced Settings for Calendar Slicers

Expand the Advanced Settings to make changes to the calendar slicer:

Year Start (Day/ Month)

By default, the year start is set to 01 January, but this can be changed by selecting a month and/ or date from the Year Start field. For instance, you may want to change the year start to the beginning of the fiscal year.

Changes to the year start date are reflected in several of the date/ time groupings. For instance, if you set the year start to 01 July, then:

  • Semester 1 will be the first 6 month period from 01 July.
  • Q1 will reflect the first 3-month period from 01 July (July-September).
  • The 7-day period beginning on 01 July is the first week of the year.

Next, from the Year Start drop-down, select if the year start is this year or next year. For example, if you're filtering for an academic year, beginning on 01 September, you need to choose if the start date (01 September) refers to this year, or next year.

Week Start

By default, the week start is set to Sunday. You can change the week start by selecting a different day from the Week Start drop-down. For instance, if the week start is Monday in your organization, you can change the week start to Monday.

In the example below, the week start was set to Wednesday:

Display Option

From the drop-down, select which types of calendar picker to display: simple, range, and/ or formula.

Show Granularity

By default, granularity is enabled, meaning you can change the granularity in the calendar picker in order to filter by a variety of date/ time groupings, like year, quarter, or week.

If you disable granularity, then only the date grouping will be enabled in the calendar picker.