Calendar Heatmap by SmartVisuals
by SmartVisuals.io
Calendar and matrix heatmap: year strips, month grid, punch card, fiscal years, holidays, rules
Every heatmap your dates can make, in one visual. See at a glance which days, weeks and hours run high or low, and where the holidays, shutdowns and gaps are. Drop in a date and a measure and get a GitHub-style year strip with weekly totals, a weekday profile and a one-line insight. Switch to a wall-calendar month grid, or to a matrix heatmap of weekdays, weeks, months and years - or any two fields, no dates needed.
Knows the calendars businesses report in. Fiscal years with any start month, ISO or "1 January = week 1" week numbers, weeks starting Monday, Sunday or Saturday, holidays from your own table, and (premium) built-in holidays for 21 countries and retail 4-4-5 / 4-5-4 / 5-4-4 years with 52/53 weeks. Date hierarchies work as-is.
Free features (the free tier is a complete calendar heatmap, not a demo):
- The last 2 years of data in a year strip, month grid with click-to-zoom, or matrix heatmap (weekday x month, year x month, month x day, weekday x week, or any two fields)
- Row and column totals, sparkline margins (weekday profile, weekly totals)
- Linear, quantile, log and manual-threshold scales, diverging centres, fixed min/max, smart range, 10 palettes incl. colour-blind-safe viridis and cividis, report theme colour
- 4 themes with their own personality: rounded tiles, dark glow, editorial squares, dot matrix
- Conditional formatting: Power BI fx on the day colour, and up to 3 rules on the value (above, below, between, top or bottom N) with a fill or a star, flag, check or other badge, named in the legend
- Data labels: values in cells (when they fit), day numbers, month and weekday labels, year totals; dynamic format strings
- Legend top or bottom, with title and rule/marker entries
- On-object formatting on the canvas
- Notes from your data or pinned in the pane, with event categories: own colours, legend toggles to hide one; holiday column, today marker
- KPI line with total, per day, best day, streak and one "vs target" and "vs prior year" figure; insight sentence; prior-year value and change in the day tooltips
- Interaction: cross-filtering and highlighting, date ranges by drag or Shift+click, Ctrl multi-select, drill-through and context menu, bookmarks, tooltips with extra fields and report page tooltips
- Responsive: portrait tiles switch to month grids, small tiles shed text before the calendar shrinks
- Localized in 20 languages (incl. screen-reader labels; dates follow the report): English, Czech, Danish, Dutch, French, German, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (BR, PT), Slovak, Spanish, Swedish, Turkish, Chinese (Simplified, Traditional)
Accessibility (free): fully keyboard-operable - one tab stop, arrow keys by day and week, Home/End, Enter or Space to select, Esc to clear - and focusing a day opens its tooltip. Screen-reader labels on every day (date, value, rule, notes). An Accessibility card in the format pane sets the focus outline colour and width and a minimum text size. High-contrast mode uses the system colours and outlines every cell; holidays are hatched and rules show badges, so meaning never relies on colour alone.
Premium features (per-user license via Microsoft Marketplace):
- Colour every day by target attainment - above or below plan at a glance
- Colour every day by change versus last year (same weekday or same date), like-for-like year-over-year change in the year headers
- Retail 4-4-5 / 4-5-4 / 5-4-4 fiscal years with 52/53 weeks and P1-P12 periods
- Small multiples: one calendar per plant, team or product, shared or independent scales
- Measure switching in the format pane and for report readers
- Unusual-day detection that ignores holidays and shutdowns and judges each weekday against its own normal
- Rules on target, attainment %, change versus prior year or unusual days
- Full history beyond 2 years, built-in holidays for 21 countries, weekday x hour punch card, matrix % of row / column / total, 2-8 note markers per day
Every premium feature is unlocked while editing, so you can build and test everything before buying. Unlicensed viewers always see a working calendar with the free features - never a blocked or watermarked visual. No data leaves Power BI: the visual makes no external calls.
New in 1.1.0.0: on-object formatting, fx day colour, note categories, date-range selection, dynamic format strings. History beyond 2 years, the punch card, matrix % and built-in holidays are now Premium. Reports created before 1.1.0.0 keep these features.
Documentation: https://smartvisuals.io/visuals/calendar-heatmap - Support: https://smartvisuals.io/support#calendar-heatmap - Release notes: https://smartvisuals.io/changelog#calendar-heatmap - hello@smartvisuals.io
Visual capabilities
- Can access external services or resources