2023 Week 06 | Power BI: Create a Calendar Heatmap


For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered. 


Create a calendar visual:

  • Show day of the week on rows and week on columns. (Hint: If you get stuck on how to handle the week, see this great calendar heatmap from Davide Bacci.) 
  • Add small multiple columns and rows so you have month on columns and city on rows.  
  • Use the max temperature (TMAX) values to color the marks. 
  • Use one of the sequential single-hue schemes available in Vega-Lite (the example uses “oranges”).
  • Order the cities by latitude descending.
  • Add a legend above the calendar. 

Create a tooltip report to appear when hovering on a date in the calendar heatmap:

  • Fields to include: Date, Location, Max temp, Min temp 


This week’s data comes from the National Centers for Environmental Information. Go to https://www.ncei.noaa.gov/access/search/data-search/daily-summaries.

Use the following inputs:

  • Data types: Maximum temperature, Minimum temperature
  • Begin date: 2022-01-01
  • End date: 2022-12-31
  • Stations: USW00023234, USW00094290, USW00093134, USW00024229

Configure the downloads with the following properties:

  • Output format: csv
  • Include Attributes: yes
  • Include Station Location: yes
  • Include Station Name: yes
  • Units: Standard
Then add the order to your cart. The download is free. You must enter an email address. You will receive an email with a link with your download (it’s usually only a couple of minutes after submission). Your download should be a CSV containing data from all 4 locations.


After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, and @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.


Download the PBIX. 

Need some inspiration? Check out Calendar Example.

1 thought on “2023 Week 06 | Power BI: Create a Calendar Heatmap”

Comments are closed.

Scroll to Top