Skip to main content

Defaults

The value each setting has before it is changed. A new visual also gets the Default template, which sets lines, banding, outline and spacing to its own values (see that page); where the table below says "template", the template decides.

Text​

SettingDefault
FontSegoe UI, 12 px, #000000; not bold, italic, underlined or struck through
Horizontal alignment of valuesRight (row labels: left, set by the template)
Vertical alignmentTop
Number formatPower BI (the data source's format; whole numbers when it has none)
Decimals once Increase / Decrease Decimal is used2
Link color#0563C1

Cell borders and fill​

SettingDefault
Border pen color / style#000000, Thin (1 px solid)
FillOff; #FFFFFF, 100 % opacity when switched on
Last used Font Color / Background Color of the buttonsBlue #0000FF / red #FF0000 (until you pick one in a session)

Sizes​

SettingDefault
Row label column width180 px
Value column width100 px
Chart column width160 px
Smallest / largest width you can set40 px / 1000 px

View settings​

SettingDefault
Freeze PanesNothing frozen
Layer TogglesOff; Show Loading Indicators off; Show Unloaded Layers on
Spacing without a templateColumns 4, Groups 0, Rows 0, Cell padding 0, Indent 20
Collapse Repeating Levels / Hide NULL RowsOff / Off
Row TotalOn, at the bottom
Row SubtotalsAt the top
Column TotalOff (start: at the end)
Row HeaderOn, text "Rows"
Collapse / Expand Icons (columns, rows)Box
Filtered Content Hint (the eye)Off
Undo / Redo buttonsOn
Row Banding, lines, outline, Financial HeadersSet by the template

Loading​

SettingDefault
Loading strategyAsked once on the first start
Preload RowsOff

Charts​

SettingDefault
Color Positive / Color Negative#8cb400 / #ff0000
Marker color (needle)#595959
Line thickness / Round / FinancialMedium / Off / Auto
Show values / PositionOn / Next to the line
Value colorThe column's text color
Middle line: show / centeredOn / Off
Middle line: thickness / FinancialThin / Auto
Marker: thickness / FinancialMedium / Auto
TooltipsOn
Connectors (waterfall)On, #a5a5a5

Conditional Formatting​

SettingDefault
New ruleOn, kind "If ... then" (Value, is greater than), first ready-made format (light red fill with dark red text)
Top / BottomTop, 10 items
Above / Below averageAbove average
Duplicates / UniqueDuplicate values
Color scale#f8696b to #63be7b; a midpoint, when added, #ffeb84 at the 50th percentile
Data bar#638ec6, gradient fill

Selection and highlight colors​

WhatColor
Selected column or header#3b82f6 (blue)
Selected row#10b981 (green)
Selected cell#8b5cf6 (purple)
Copy flash#5b21b6