Set up the visual
Add the visual and fill its fields
Add Smart Matrix to a report page like any other Power BI visual. It has three field wells:
| Well | Kind | What goes in |
|---|---|---|
| Rows | Grouping | The fields that make up the row hierarchy. The first field is the top layer (Layer 1), the second field the next layer, and so on. |
| Columns | Grouping | The fields that make up groups of columns, for example Year, then Quarter. Leave it empty for a table with only the measures as columns. |
| Values | Measure | The measures. Each measure becomes a column (or one column per column group). |
📷 Screenshot needed:
field-wells.png- the Fields pane of the visual with a Rows hierarchy of three fields, one Columns field and two measures in Values.
Drilling
The Rows well supports Power BI's drill buttons. When you drill down with Power BI's own controls, Smart Matrix opens the rows above the new layer for you, so the new layer is visible at once. The opened rows are saved with the report. Drilling up does not open or close anything by itself.
This only applies to a drill that you make with Power BI's controls. Rows that you open with the + icon, with the
Layer Toggles or with the preload are not treated as a drill.
How rows load
A new visual loads On-Demand: a row's children are fetched from Power BI only when the row is opened. That suits a very deep or wide hierarchy. There is no question to answer first; the table is drawn at once.
If you would rather have the whole hierarchy up front, switch to Full Loading in Start tab > Loading. See Loading strategies for what each one does.
A new visual starts with the Default template
A visual that was just added to a report gets the Default template automatically. Nothing is set to anything unusual; pick another template or change single options whenever you like. A report that was saved before keeps the look it had.
Where do I change things?
All formatting is done inside the visual, in Focus Mode, with the ribbon and the side panels. Power BI's own Format pane only contains a License card, to see which license the visual has and to enter a license key - see License. The visual works without one (the free version); you do not need the card for formatting.