View tab
The View tab sets the look of the whole table, not of a selection. Four sections: Templates, Spacing, Display and Design.
📷 Screenshot needed:
view-tab.png- the whole View tab.
Templates​
| Button | What it does |
|---|---|
| Templates | Opens the Templates panel to switch the whole matrix between built-in looks (fonts, colors, borders, alternating rows, subtotal styling). |
Spacing​
| Button | What it does |
|---|---|
| Spacing | Opens the Spacing panel: the space between columns, between groups of columns and between rows, the room around the text of a row, and the indent of the row hierarchy. The button looks pressed while the panel is open. |
Display​
Freeze Panes​
Keeps the column headers and/or the leftmost row-label column in place while you scroll (Excel's Freeze Panes). The button looks pressed while something is frozen. Menu:
| Entry | Result |
|---|---|
| Freeze Both | Header and first column stay. |
| Top Row | Only the header stays. |
| First Column | Only the row labels stay. |
| Unfreeze | Only shown while something is frozen. |
Each entry sets exactly that combination (Top Row while the first column was frozen releases the first column). The entry that matches the current state is marked. Default: nothing frozen.
Layer Toggles​
Shows the numbered button bar above the table and sets its two options. Details in Layer Toggles. Menu: Display (On / Off), Settings > Show Loading Indicators, Show Unloaded Layers. Default: Off.
Financial Headers​
Switches the Financial Header markers on and off and opens their settings. Menu:
| Entry | What it does |
|---|---|
| Display > On / Off | Draw the marker under measure headers (Actual / Plan / Forecast / Previous Year / Deviation). A template can switch it on or off when you pick it; this switch is in charge afterwards. |
| Settings | Opens a dialog: for each of the five headers, its marker as drawn in a header, the color of its line (pick from the color menu) and a Default button that goes back to the standard color. OK applies; Cancel, Esc, the cross and a click beside the dialog close it. |
Collapse / Expand Icons​
The look of the buttons that open and close a row, or a group of columns. Two sections, Column and Row, each with the same four looks, shown as the closed and open state:
| Look | Name |
|---|---|
+ and - | Plus / Minus |
| Plus/minus in a square box | Box (default) |
| Plus/minus in a rounded box | Rounded Box |
< / > style arrows | Arrows |
The name appears as the tooltip of a row. Columns and rows can have different looks.
Filtered Content Hint​
An eye icon in the floating strip that shows up while rows or columns are hidden (with Hide Row / Hide Column). A click opens a list of everything hidden - Hidden rows (n) and Hidden columns (n) - and a click on an entry shows it again; Show All Rows / Show All Columns appears when there is more than one. The list stays open for the next click and closes with the last thing you showed.
This button's menu has one section, Display (On / Off). Default: Off, so the eye only appears if you switch it on.
Undo / Redo Buttons​
The two buttons at the top right of the visual (in the tab strip in Focus Mode, floating over the table otherwise) that step back and forth over your changes. This menu switches them on and off (Display > On / Off, default On). The history is kept while they are off. See Saving, Undo and Reset.
Row Header​
The text in the corner of the table, above the row labels. Menu:
| Entry | What it does |
|---|---|
| Display > On / Off | Show the text or leave the corner empty. Default On. |
| Name > Rename... | Edit the text where it stands, like Rename Column does for a column. Default text: Rows. |
| Name > Reset Name | Back to "Rows". Greyed out while the name is the default. |
Design​
Row Banding​
Shades every second row. Menu:
| Section | Entries |
|---|---|
| Display | On / Off |
| Background Colors | Even Color, Odd Color |
| Font Colors | Even Color, Odd Color |
The color entries are greyed out while banding is off ("Enable Row Banding first"). Until you choose a color, the template's
color applies (even rows #EEEDED, odd rows white if the template has none).
Horizontal Lines and Vertical Lines​
The thin lines above and below the cells (Horizontal) or at their sides (Vertical). Both menus have two sections, Body and Header, each with On / Off and a Color entry. Until you choose, the template's setting and color apply.
Outline​
A frame around the matrix - the line under the header and the line right of the first column (the light blue lines of the standard Power BI matrix). Menu: Display (On / Off) and Color. Until you choose, the template decides.
What a template switches on, off or colors (lines, banding, outline, spacing, Financial Headers) is set when you pick the template. After that the View tab's own switches take over, so you can adjust any of it.