Creating and Formatting Date Slicers

Date slicers offer more choices than typical data slicers.

Date slicers are typically added at the end of the report creation process.
  1. Open the report to which you want to add a date slicer.
  2. In the Visualizations pane, select Slicer.
    The Visualizations pane with Slicer circled in red.
  3. In the Fields pane, Search for and select the Date field.
    The Fields pane with the selected Date field circled in red.
  4. On the date slicer visual, select the dropdown arrow and then an option.
    A date slicer with the dropdown arrow circled in red and a list of available options.
    • Between. Shows from and to fields. Both can be updated.
    • Before. Dims the from field. The to field can be updated
    • After. Dims the to field. The from field can be updated.
    • List. Dates can be selected using checkboxes.
    • Dropdown. Dates can be selected using a dropdown list of checkboxes.
    • Relative Date. Dates are defined based on the current date. Select Last, Next, or This; enter a number; and select the time unit to use (for example, Days or Months).
    • Relative Time. Times are defined based on the current time. Select Last, Next, or This; enter a number; and select the time unit to use (Hours or Minutes).
  5. If needed, you can apply filters to the date slicer visual. In the Filters pane, select the Date filter and then a Filter type.
    The Filters pane with Basic filtering circled in red.
    • Advanced filtering. Define the circumstances under which data should be shown. For example, when the value is before 8/1/2021 at 12:00 PM and is on or after 7/1/2021 at 12:00 PM.
    • Basic filtering. Select the dates to filter by.
    • Relative date. Dates are defined based on the current date. Select Last, Next, or This; enter a number; and select the date unit to use. For example, in the last seven (7) days.
    • Relative time. Times are defined based on the current time. Select Last, Next, or This; enter a number; and select the time unit to use (Hours or Minutes). For example, in the next three (3) hours.
    • Top N. Select Top or Bottom, enter the number (for example, three (3)), and the value to use.
  6. Edit the canvas to include the slicer as desired.
    The report canvas with a date slicer visual circled in red.
  7. To format the slicer, do the following:
    1. Select Format.
      The Visualizations pane showing the Format option circled in red.
    2. In the General section, select an Outline color and Outline weight.
    3. To allow the slicer to accommodate the report user's screen size, select Orientation Horizontal and turn on the Responsive toggle.
    4. Set the slicer size and position on the report canvas, or define it using the X Position, Y Position, Width, and Height options.
    5. Define Alt Text that describes the slicer for screen readers.
    6. Define other formatting options as desired.
      Formatting options include things like changing the slicer title and the title display color, changing the visual icon color, and defining whether certain Visual header options (action items) should be available (for example, the More options icon). Formatting can help power users make information even more accessible to consumers reading the report.