Customize a date slicer

Slicer visuals contain powerful filtering options when used with Date data types, including graphical date selection, before/after criteria, and Relative dates such as the last 4 weeks.

  1. Add a date column to the canvas.
    • A hierarchy is created in the field well by default.
    • Click on the drop-down arrow for the date column in the field well and switch from Date Hierarchy to Date.
  1. Switch to the slicer visualization.
    • By default, a timeline element is exposed below the start and end Date parameter inputs.
Slicer Visual Options for Date Data Types
  • Between is the default filter setting, per the preceding screenshot ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.