Power BI Custom Visual Calendar Heatmap Date Analytics

ProCalendar Heatmap User Guide

ProCalendar Heatmap is an analytical calendar visual for Power BI. It answers when activity happens: which days, months, years, fiscal quarters, and hours carry the most volume, outliers, or gaps. It is not an appointment scheduler or event calendar.

Getting Started

Five steps from blank visual to a useful calendar heatmap.

1

Step 1: Bind Date and Value

Date and Value are required. Date can be Date or DateTime. Value must be numeric and drives the color intensity unless multi-metric display is enabled.

2

Step 2: Pick the Right Heatmap Mode

Use Month Heatmap for familiar daily calendars, Annual Heatmap for one-year focus, Multi-Year for year comparison, Fiscal Quarter for Q1-Q4 reporting, and Week x Hour for operational DateTime patterns.

3

Step 3: Choose the Date Range

Calendar View contains Auto, Fixed range, and Relative to today. Fixed range is best for reproducible screenshots and review pages.

4

Step 4: Tune the Color Scale Domain

Auto by mode chooses a sensible min/max. Use Manual when you need consistent color meaning across pages or screenshots.

5

Step 5: Add Context

Bind Tooltip Fields, configure Holidays & Non-working, turn on Today Indicator, and use Legend settings so report consumers can interpret the heatmap without explanation.

Quick Reference

Rules that explain most ProCalendar Heatmap behavior.

Required roles

Date + Value

Daily grouping

Daily modes group by local YYYY-MM-DD

Week x Hour input

Requires DateTime with real time-of-day

Annual focus

Selected year or latest data year

Free visible range

366 days anchored to latest date

Multi-Year scale

Auto uses Date Range for comparability

Manual scale

Use Minimum value + Maximum value

Same-day rows

Aggregated; selections include all source rows

Null vs zero

Null and 0 are rendered differently

Threshold rules

Pro-only; visible when Scale type is Threshold rules

Feature Reference

The core concepts behind the visual.

Data Roles
Date - Required. Used for every date key and selection identity. DateTime values preserve hour data for Week x Hour Heatmap.
Value - Required numeric measure. Used for color intensity, legend values, and tooltip value display.
Secondary Value and Tertiary Value - Optional. Used in tooltips and Pro multi-metric display modes such as Split cell and Composite color.
Category - Optional context shown in tooltip and useful for cross-filtering report pages.
Holiday - Optional holiday indicator. Can drive holiday highlighting when Holiday source is set to data field.
Tooltip Fields - Any additional columns or measures you want Power BI to surface in the hover tooltip.
Calendar View
Mode - Annual, Month, Multi-Year, Fiscal Quarter, or Week x Hour. Free users see Annual and Month. Pro users see all five.
Range mode - Auto uses the data extent. Fixed range uses entered start/end dates. Relative to today uses presets such as this year, last 12 months, or last 5 years.
Selected year - Visible in Annual Heatmap. Blank or invalid input falls back to the latest year in the current data.
Fiscal year starts - Pro-only and visible where fiscal alignment matters. For example, fiscal start April makes FY 2026 run Apr 1, 2026 to Mar 31, 2027.
Aggregation and Hour format - Visible in Week x Hour Heatmap. Choose sum, average, min, max, or count and 12-hour or 24-hour labels.
Color Scale
Scale type - Sequential for intensity, Diverging for negative/positive or below/above target, Threshold rules for discrete status buckets.
Domain source - Auto by mode, Current view, Date range, All loaded data, or Manual. This controls the min/max values used by color intensity and legend labels.
Manual min/max - Use when a color should mean the same value across pages, modes, or report refreshes.
Out-of-range colors - When enabled, values below manual minimum or above manual maximum use underflow and overflow colors.
Null color - Distinct from zero. Null means no usable numeric value; zero is a valid numeric value.
Mode Selection
Annual Heatmap - Best for one selected year. Uses a focused title/subtitle and strong within-year contrast.
Month Heatmap - Best for report consumers who expect calendar panels and day numbers.
Multi-Year Heatmap - Best for comparing multiple years with consistent color meaning.
Fiscal Quarter Heatmap - Best for quarterly business reviews and fiscal-year reporting.
Week x Hour Heatmap - Best for DateTime event or workload data where hour-of-week patterns matter.
Interaction
Click a cell - Selects the date or bucket and cross-filters other visuals. If multiple source rows map to the same day, all corresponding selection IDs are selected.
Ctrl + click - Adds another date or bucket to the current selection.
Click empty space - Clears the selection.
Right click - Opens the Power BI context menu.
Today button - Scrolls the visual to the current date when that date is inside the visible range.

Need help with your dataset?

Send us the field roles, mode, and a screenshot of the format pane. We can usually spot setup issues quickly.

Contact Support