Calendar Heatmap in Power BI
no custom visuals

When you see "over time" in requirements, the first instinct is usually a line chart or a bar chart. But when thinking about time, most people don't actually visualize it as a straight line - they visualize it as a calendar grid. That's how schedules, deadlines, and patterns live in the brain.

A calendar heatmap gives you a day-by-day breakdown - clear, concise, and perfect for spotting patterns that a line chart completely hides: which weekdays are consistently high, which weeks in a month are outliers, how a metric behaves across a full year at once.

The result - a full-year calendar with gradient heatmap, built entirely with the native Matrix visual.

When this is the right visual

The calendar heatmap requires three tables. The key insight is the Weeks table - a simple helper that enables the Matrix to render week rows correctly inside each month.

Data model - three tables connected to build the calendar structure.

The calendar layout is achieved by configuring the Matrix visual with specific row and column fields. Several of these are intentionally invisible - they control the structure without showing labels.

One measure drives the entire calendar display. It handles two jobs: showing the month name in the header row (Week 0), and showing the day number in all other cells. Here's the full measure with comments explaining each branch.

Calendar Value =

VAR _MonthName = SELECTEDVALUE('Calendar'[Month Name Short])

VAR _day =
    FORMAT(
        CALCULATE(
            SELECTEDVALUE('Calendar'[Day Number]),
            'Calendar'[Week of Month] = SELECTEDVALUE(Weeks[Week Number])
        ),
        "0"
    )

VAR _DayCountWeek =
    COUNTROWS(
        INTERSECT(
            VALUES(Weeks[Week Number]),
            VALUES('Calendar'[Week of Month])
        )
    )

RETURN SWITCH(
        TRUE(),

        -- Week 0 + Wednesday column: show the Month Name SELECTEDVALUE('Calendar'[Day Name Short]) = "Wed" &&
        SELECTEDVALUE(Weeks[Week Number]) = 0,
            _MonthName,

        -- No days exist for this week number: blank cell ISBLANK(_DayCountWeek),
            BLANK(),

        -- Week 0 (non-Wed) or multiple Day Name values: blank SELECTEDVALUE(Weeks[Week Number]) = 0 ||
        NOT HASONEVALUE('Calendar'[Day Name Short]),
            BLANK(),

        -- Default: return the day number
        _day
    )

How the SWITCH logic works