Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image2_icon300.png

Calendar Heatmap by SmartVisuals

by SmartVisuals.io

Free Trial
Download SampleInstructions

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

When this visual is used, it
  • Can access external services or resources

At a glance

https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image1_01yearstrip.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image1_01yearstrip.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image5_02targetmonthgrid.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image0_03punchcard.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image4_04smallmultiplesyoy.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-calendar-heatmap-66a6fae9-da3e-4373-a79b-efc7f93926da/image3_05retail445.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies