Forum Discussion
Help with Calendar Heat map
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
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.
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???