Date Slicer by SmartVisuals

A date slicer that knows your calendar. Pick dates the fast way - one click on a preset, two clicks in the calendar, a drag across the timeline or typed dates in your own format - and always see in plain words what is selected: "Month to date, Sep 1 - 27, 2026, 27 days, 19 working days".

Presets that keep rolling after you publish. Save the report on Month to date and it is still month to date next week - no one has to log in and move the slicer. Your viewers can always pick something else; Reset brings the default back.

Free features - no licence needed:

• Calendar (1-3 months), timeline with year / quarter / month / week / day, compact bar with previous / next stepping, presets list; Auto picks the layout that fits the space and falls back to the presets list or a one-line compact bar on small tiles
• Relative date presets: today, this / last / next week, month, quarter, half-year and year, week / month / quarter / year to date, last 7 / 30 / 90 / 365 days, rolling and full 12 months - and viewers can pick their own "last or next N days, weeks, months, quarters or years"
• Presets that end on the latest date with data instead of today - set when the report opens and moved forward only when later data appears, never pulled back by filtering in other visuals
• Fiscal years from any month; weeks starting Monday, Sunday or Saturday; ISO week numbers
• Public holidays for 21 countries computed offline, weekend shading, working-day counts
• Range selection (between) and single date selection (single day, on or after, on or before); timeline selection by period; Apply button for heavy models
• Current selection display in the header; default selection of any preset or None (all dates); a Clear button that selects all dates again and a Reset button
• Custom date format (medium, short, long, ISO); typed dates in the date column's own format
• Bookmarks, sync slicers (with the Date field alone), date hierarchies, data density bars from a measure, tooltips with up to 5 extra measures, report page tooltips and dynamic format strings
• On-object formatting: click the header, presets, calendar, timeline or date entry in format mode to style it in place
• 4 themes with their own personality: SmartVisuals, Dark, Clean, Slate
• Localized in 20 languages, among them Chinese, French, German, Japanese, Portuguese and Spanish: the format pane, presets, header and on-visual labels; month and weekday names and date formats follow the viewer's locale, holiday names stay in each country's language

Accessibility (free): full keyboard navigation - the calendar is a grid (arrows by day and week, Home / End, Page Up / Down by month or with Shift by year, Enter to pick, Shift+Enter to extend, Esc to cancel), the presets and the granularity switch move with the arrow keys and the timeline is a keyboard list. Screen readers hear every day and period with its full label, and the applied range is announced. High contrast mode uses the system colours. An Accessibility card sets the focus outline colour and width, a minimum text size and a strike-through for dates without data, so that cue does not rely on colour alone.

Premium - Period intelligence (per-user licence via Microsoft Marketplace, first month free):

• Compare any two ranges - viewers pick a second range of their own in the calendar, on the timeline, with a preset or by typing, and it stays put while they change the main range
• Comparison period - previous period, same period last year, 52 weeks back or your own offset (N days, weeks, months, quarters or years back) - drawn as a band with its dates in the calendar and on the timeline and written to a comparison date column, so one line of DAX gives any measure its comparison
• Filter working days only, and "last N working days" presets
• Retail 4-4-5 / 4-5-4 / 5-4-4 years with 52/53 weeks

A saved report keeps rolling; a bookmark keeps the dates it captured.

Every premium feature is unlocked while editing, so you can build and test everything before buying. Viewers without a licence always get a working slicer with the free features - never a blocked or watermarked visual. No data leaves Power BI: the visual makes no external calls.

Built for finance, sales and operations reports that live on months, quarters, fiscal and retail periods.

New in 1.1.0.0: compare any two ranges, a custom comparison offset, the comparison as a band, on-object formatting, dynamic format strings.

Documentation, FAQ and keyboard guide: https://smartvisuals.io/visuals/date-slicer - Release notes: https://smartvisuals.io/changelog#date-slicer - Support: https://smartvisuals.io/support#date-slicer - hello@smartvisuals.io - Feature requests and bug reports: https://smartvisuals.io/feedback