How to Create a Training Load Calendar Heatmap in Power BI

How to Create a Calendar-Style Heatmap for Training Load Metrics with Power BI

In this post, we will walk through a step-by-step guide on how to create a calendar-style heatmap in Power BI using Training Load data, without relying on third-party apps or paid custom visuals.

This tutorial is designed to enhance the readability of your datasets, and the method can be applied to any internal or external workload parameter. By leveraging conditional formatting, we can illustrate trends throughout the season, presenting them in a calendar format where color density highlights the magnitude of the load.

Step 1 - File Upload

The first phase involves uploading the source file containing the data for a medium-to-long-term period. For the sake of clarity in this tutorial, I have included the team's total distance data (Team Average) for every training session, spanning from August (pre-season) through April.

Step 2 - Creating the Matrix

In this tutorial, we will explore a straightforward procedure for generating a Heatmap without using external add-ons or paid applications—everything is achieved simply through DAX language. In this second step, we will focus on building our Matrix.

In this phase, we will input our data—specifically the Date and the external load value (Total Distance).

However, be careful: if you use a time interval spanning from August 2024 to April 2025, as in our example, the default month order will be incorrect. As shown in the image below, the calendar will automatically start from January, failing to respect the actual chronological sequence of the sports season.

To fix the chronological order, it is essential to perform an intermediate step by creating two new columns.

Step 3 - Creating the "Season Index" Column

This step involves creating an "index" that allows each individual daily value to be sorted chronologically. This ensures that the data flows correctly according to the timeline of the sports season rather than alphabetically.

To do this, create a new column by entering the following DAX command:

Season Index =
IF (
MONTH ( '20260331SeasonExport'[Data] ) >= 8, 
MONTH ( '20260331SeasonExport'[Data] ) - 7, 
MONTH ( '20260331SeasonExport'[Data] ) + 5
)

Step 4 - Creating the "Month Name" Column

The next step is to create a new column that defines the month labels as they will appear on your Heatmap / Calendar. This ensures the output is readable and professionally formatted.

Enter the following formula in DAX:

Month Name 
FORMAT (
'20260331SeasonExport'[Data],
"MMM yy", 
"en-US"
)

Step 5 - Populating the Matrix Fields (Heatmap)

Once the two auxiliary columns have been created to resolve the chronological sorting issue, we can proceed to populate the matrix with the correct data. Configure the rows and columns as shown in the image:

• Rows: Month Name

• Columns: Date (Day)

• Values: Total Distance (Sum)

Step 6 - Conditional Color Formatting (The Heatmap)

The final step is to apply conditional formatting, where each cell is colored based on the magnitude of the specific training parameter. Simply select your matrix, go to the "Cell elements" pane, toggle "Background color" on, and choose a 2 or 3-color scale to represent your data ranges.

This completes the process of creating your custom Calendar Heatmap. From here, you can finalize the layout by adding a title or adjusting design details to suit your needs.

Pro Tip: Since native matrices in Power BI do not include a color legend, a practical workaround is to manually add shapes (circles or squares) using the corresponding colors, paired with text labels such as "Low," "Medium," or "High."

If you would like to download the complete Power BI Dashboard, you can access it via the link below: 📁 PowerBi Dashboard | Create a Heatmap Calendar