Quick Start
Calendar Events Heatmap overlays your KPI heatmap with event badges (promotions, campaigns, holidays) in a single calendar surface. Three steps to get started:
- Add the visual to your report canvas.
- Drag a Date column to the Date field well and a measure to Main Measure. The calendar heatmap appears immediately.
- Drag event name and event category columns to see colored event badges on each day.
Field Wells
| Field | Type | Required | Description |
|---|---|---|---|
| Date | Date column | Yes | One row per day. All other fields (events, holidays) use this same date column via your data model. |
| Main Measure | Measure | Yes | Drives the heatmap color intensity. Aggregated per day. |
| Tooltip Measures | Measure(s) | No | Additional measures shown in the tooltip only. Multiple fields accepted. |
| Event Name | Text column | No | Name displayed in the event badge on each calendar day. |
| Event Category | Text column | No | Category of the event (e.g. "Promotion", "Campaign"). Used for color coding. PRO per-category colors configurable. |
| Holiday Name | Text column | No | Name of the holiday. The date is taken from the Date field — no separate date column needed. |
Format Pane Reference
Calendar
| Setting | Tier | Description |
|---|---|---|
| Default View | FREE | Month or Week. The view persists across resizes; only the first load uses this default. |
| Months to Display | PRO | Show 1–12 months side by side. Free tier always shows 1 month. |
| Week Starts On | FREE | Monday or Sunday. |
| Fiscal Calendar | FREE | Enable fiscal year offset. |
Heatmap Colors
| Setting | Tier | Description |
|---|---|---|
| Min Color | FREE | Color for the lowest measure value. |
| Max Color | FREE | Color for the highest measure value. |
| No Data Color | FREE | Color for days with no measure data. |
Day Number
| Setting | Tier | Description |
|---|---|---|
| Font Size / Family / Color | FREE | Style for regular day numbers. |
| Weekend Color | FREE | Color for Saturday and Sunday numbers. |
| Holiday Color | FREE | Color for days marked as holidays. |
Events
| Setting | Tier | Description |
|---|---|---|
| Show Events | FREE | Toggle event badge visibility. |
| Max Events per Day | PRO | Max badges per cell in month view. Free tier shows 1 event per day. |
| Single color for all events | PRO | When ON, overrides per-category colors with a single badge color. |
| Event Text Color / Font Size | PRO | Badge label styling. |
Event Category Colors PRO
One color picker per event category (up to 8). Categories appear in order of first occurrence in the data. The visual shows a color legend below the Month/Week buttons mapping each color to its category name.
Measure Labels / View Buttons PRO
Font and color settings for measure labels and navigation buttons. Available in Pro.
Free vs Pro
| Feature | Free | Pro ($9.99/mo) |
|---|---|---|
| Month view | ✅ 1 month | ✅ 1–12 months |
| Week view | 🔒 | ✅ |
| KPI heatmap | ✅ | ✅ |
| Event badges | ✅ 1/day | ✅ configurable |
| Event category colors | Auto palette | ✅ fully configurable |
| Holiday overlay | ✅ | ✅ |
| Tooltip measures | ✅ | ✅ |
| Cross-page filtering | ✅ | ✅ |
| Full format pane | Basic | ✅ full |
| 30-day full trial | ✅ All Pro features during trial | |
FAQ
My dates show as "1900" or the wrong year
Power BI's Auto Date/Time hierarchy sends year numbers instead of full dates. Click the ▼ next to your date field in the field well and select Date (not Date Hierarchy). Alternatively disable Auto Date/Time in File → Options → Current file → Data Load.
Slicers stop working after clicking a day
Click on any empty area of the calendar to deselect the current day and restore cross-filtering.
How do I connect holidays?
Add a Holiday Name column to your main table via Power Query (merge with your holidays table on the Date key). Connect that column to the Holiday Name field well. The visual uses the Date field for the holiday date — no separate date column is needed.
Events appear on wrong days
Make sure your events table is expanded per day (one row per event-day combination) before connecting to the visual. The visual does not expand date ranges internally.
Colors reset after saving the report
Event category colors are stored per report. If they reset, check that the Event Category field is still connected and that category names haven't changed in your data source.
How does the trial work?
The 30-day trial gives full Pro access. No credit card required to start. After the trial, the visual switches to the Free tier automatically.