https://catalogartifact.azureedge.net/publicartifacts/tino_callarisa.dynamic-matrix-heatmap-8eb061de-2a7b-443d-9834-52347fd2ede4/image3_dynamicmatrix300x300.png
Dynamic Matrix Heatmap
A pivot table with a heatmap that your readers turn themselves: rows, columns, % and subtotals.
A Power BI matrix answers the question its author had. Readers who want the rows by product instead of region, or the value as a share of the row, have to ask for another matrix, and every new question becomes a request.
Dynamic Matrix Heatmap is a pivot table with a heatmap that the reader turns. Rows, columns, the value and how it is shown are dropdowns inside the visual: whoever reads the report picks the view they need and the heatmap redraws. Nobody edits anything, and no DAX is needed.
PIVOT IN THE REPORT
• X, Y and the value are chosen inside the visual, by whoever is reading it
• Show as: absolute, % of row, % of column or % of grand total — each measure remembers its own (Pro)
• Group rows by a third dimension, with subtotals that open and close (Pro)
• Click a column header to sort the rows by it; order by name or total; days and months in calendar order
• Others: beyond the number of rows or columns you set, the smallest categories are grouped so the totals still add up
• Order by similarity puts rows with the same pattern side by side (Pro)
NUMBERS THAT SURVIVE THE PIVOT
Because the pair is chosen after the query has run, the numbers have to be combined again for whichever pair you picked, and not every number survives that. This visual is built around getting it right, and saying so when it cannot.
• Sums, minimums, maximums and counts combine exactly, at any pair
• Add an ID to Detail (rows) — the order, ticket or customer — and averages are exact too
• A Count (Distinct) measure is counted exactly when its column is also in the visual
• When a number cannot be combined correctly — a ratio, an average without Detail — a note says so while you edit, instead of showing a plausible wrong number
• The model's format string is used, in the report's locale
LOOK
• 12 colour schemes, two of them colour-blind safe, or your own three colours
• Colour rules: paint the cells above or below a threshold
• Style templates: Classic, Clean, Tiles, Contrast, Compact; space between cells and rounded corners
• Text on dark cells turns white by itself
WORKS LIKE A NATIVE VISUAL
• Click a cell to cross-filter the report; Ctrl+click to add; click again to clear; with row groups, a cell filters by its group too
• Bookmarks restore the selected cells; "Edit interactions" is respected
• Tooltips, the native right-click menu and highlighting from other visuals
• Format on the canvas: click values, headers or the dropdown bar to format them
• Keyboard navigation and high contrast
• Format pane and the panel in the visual in 12 languages
FREE AND PRO
The free tier gives a correct result, not a cut-down one: every number it shows is one you can take to a meeting, and nothing is watermarked in a published report. Free includes the pivot itself with 3 dimensions and 2 measures, the heatmap, colour rules, templates, Others, sorting and exact averages with Detail (rows). Pro raises the limits to 10 dimensions and 5 measures and adds Show as, totals, row groups with subtotals, order by similarity and distinct counts of Detail fields. Turn on a Pro capability without a licence while editing and it is drawn working, under a "Pro preview" watermark that names it — your own data, not a screenshot. Reading view shows the free result.
Pro comes with a one-month free trial, and can be bought monthly or annually.
PRIVACY
The visual makes no network requests of any kind: no analytics, no telemetry, no external scripts. What it writes into the report is your view — the fields chosen, how each measure is shown, the sort column and which groups are closed — like a slicer selection. Licences are checked through Microsoft's own licensing API.
GETTING STARTED
1. Add two or more fields to Dimensions and at least one to Measures.
2. Pick the rows, the columns and the value in the panel on the left of the visual.
3. Showing an average? Add an ID to Detail (rows) and it is exact.
Documentation, video and FAQ: https://tinocallarisa-web.github.io/dynamic-matrix-heatmap/support.html
Questions: https://github.com/tinocallarisa-web/dynamic-matrix-heatmap/discussions
Support: support@tcviz.com
WHAT'S NEW IN 1.2.0.0
The matrix becomes a pivot table: Show as in the visual, row groups with subtotals, sorting by any column, Others so totals always add up, order by similarity, colour rules, schemes and templates, format on the canvas and 12 languages. Detail (rows) replaces Distinct count of and Weights for averages: one optional ID makes averages and distinct counts exact.
```
Visual capabilities
This visual is certified by Power BI
At a glance
https://catalogartifact.azureedge.net/publicartifacts/tino_callarisa.dynamic-matrix-heatmap-8eb061de-2a7b-443d-9834-52347fd2ede4/image1_Screenshot1.png
https://catalogartifact.azureedge.net/publicartifacts/tino_callarisa.dynamic-matrix-heatmap-8eb061de-2a7b-443d-9834-52347fd2ede4/image1_Screenshot1.png
https://catalogartifact.azureedge.net/publicartifacts/tino_callarisa.dynamic-matrix-heatmap-8eb061de-2a7b-443d-9834-52347fd2ede4/image0_Screenshot2.png
https://catalogartifact.azureedge.net/publicartifacts/tino_callarisa.dynamic-matrix-heatmap-8eb061de-2a7b-443d-9834-52347fd2ede4/image2_infographic.png
https://catalogartifact.azureedge.net/publicartifacts/tino_callarisa.dynamic-matrix-heatmap-8eb061de-2a7b-443d-9834-52347fd2ede4/image4_infographicstyles.png