Help with Calendar Heat map

[PBIUser34]

Hi everyone

i m trying to build a calendat heat map visual similar to the attached one in the screenshot. I want all months data to be displayed and the dates in each month. The background color in each month should be based on the metric value i have. Please suggest me how can i achieve this. I just want the week names on top of 1st row only, I dont want the weekdays names to be repeated for all the rows. I have a date table and i have all the required columns in date table like week numbers, day names, etc

please suggest me how can I achieve it

[v-pgoloju]

Hi @PBIUser34,

Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @PBIUser34,

Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @PBIUser34,

Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju · Accepted solution]

Hi @PBIUser34,

Instead of managing 12 separate matrix visuals and hiding headers with background colors, I’d recommend using a Calendar Heatmap custom visual (for example, Calendar Heatmap by OKViz from AppSource). These visuals are built for exactly this purpose  they automatically arrange the months, display the dates inside each month, and apply background color based on your metric value. That way you won’t need workarounds with row/column headers or background colors, and it will look cleaner and easier to maintain.

Thanks & Regards,
Prasanna Kumar

[Shahid12523]

You can do a calendar heatmap in Power BI in 2 ways:

1.Custom Visual (easiest) → install Calendar Heatmap (OKViz) or Calendar by MAQ from AppSource → bind Date + Metric → set color scale.

2.Native Matrix →

Add Month + WeekOfMonth on Rows, DayOfWeek on Columns.

Put your measure (e.g., Payments) in Values.

Apply conditional formatting (background color).

👉 Custom visual is quickest. Matrix works if you can’t use custom visuals.

[PBIUser34]

I created something like this using the matrix visual. Created 12 matrix visual and kept each one to respective month. I inserted a text box of whole size in which these 12 fits into that. Now i have enabled the background color for both Text box and Matrix visuals(Row header and column header) to #E6E6E6. As per our standards we are not supposed to use background color for any visuals. If i take out the background color for matrix visual row headers and column headers then i m seeing my week numbers i don't want them to be visible

how can i acheieve it???