Power BI Custom Visual
Calendar Heatmap for Power BI
AI-generated calendar heatmap for Power BI. Describe what you need in plain English; download a ready-to-import .pbiviz file. Full TypeScript source included.
A calendar heatmap displays daily values in a grid where each row is a day-of-week and each column is a week (or month, with days as rows within). Each cell's color shades to a sequential or diverging palette based on the value. GitHub popularized the format with its contribution calendar; operations and analytics teams use it for anything daily — sales, traffic, incidents, login counts.
Power BI has no native calendar heatmap. Marketplace versions exist, but most render slowly on multi-year ranges, can't handle gaps cleanly, and charge per user.
VizForge generates a Power BI calendar heatmap with configurable color scale, tooltip on hover showing the exact date and value, multi-year scrolling, and highlight rings for holidays or campaign dates. Our AI writes the .pbiviz with cross-filter into other visuals.
When to use a calendar heatmap in Power BI
- Daily sales or revenue intensity across the year
- Website traffic patterns (day-of-week × week-of-year)
- Support-ticket volume by day
- System incident timeline
- User login frequency / retention calendars
Example prompt
Example VizForge prompt
Calendar heatmap of daily website visits for the past year. Sequential green color scale, darker = more visits. Label months across the top. Highlight weekend columns with a subtle grey background. Tooltip on hover shows exact date and visit count.
Data shape required
Two columns: Date (date) and Value (numeric). One row per day; gaps treated as zero or skipped depending on prompt.
Typical DAX measures
Daily Visits = SUM( Sessions[Count] )
Weekday Number = WEEKDAY( MAX( 'Date'[Date] ), 2 ) -- 1=Monday
Peak Day =
CALCULATE(
MAX( 'Date'[Date] ),
FILTER(
ALL( 'Date' ),
[Daily Visits] = CALCULATE( MAXX( ALL( 'Date' ), [Daily Visits] ) )
)
)Free plan: 3 visuals per month. No credit card required.
FAQ
Can I show multiple years stacked?
Yes. Prompt for 'one row per year' and the visual renders one calendar block per year stacked vertically, with a shared color scale.
What happens on days with no data?
By default rendered as an empty (white) cell. Prompt for 'treat missing as zero' if you want them shaded as the lowest color stop.
Can I overlay holidays?
Yes — bring a Holiday column or flag and the visual outlines those cells with a ring in the formatting pane color.
Does it cross-filter?
Yes — click a cell to filter other visuals to that date; click-drag to select a range.
How-to guides for calendar heatmap
Power BI How-To
AI-First Power BI
Decision Guide
Power BI Customization
Free .pbiviz Generator
Related visuals
AI-generated heatmap for Power BI. Density grids, correlation matrices, calendar heatmaps — continuous color-scale inten
AI-generated Gantt chart for Power BI. Timeline bars, dependencies, milestones, resource lanes — all from a plain-Englis
AI-generated SPC control chart for Power BI. Upper/lower control limits, Western Electric rules, sigma bands.
Need a related visual?
Browse the full VizForge visual catalog →