Customizing Table Writeback visual

Last updated 2 days ago

These settings are in the Power BI format pane and are typically managed by the report author.

Table Setting card

  • Table Actions group (all OFF by default):

Setting

Effect when on

Disable Create Table

Removes the Create Table tile

Disable Action Panel

Hides the whole toolbar

Disable Exit

Hides the close (X) icon so users cannot leave the table

Disable Add Row Icon

Hides the green + button at the bottom of the table

Disable Delete Row

Removes the Delete option from the row menu

Auto Save

Saves every edit immediately (hides Save, Undo and bulk add options)

Hide Table Header

Hides the header bar with the table name

Add group (all ON by default): show or hide each item of the Add menu individually:

  • Add Column

  • Add Row

  • Manage Calculated Column

  • Add Row From Dropdown

  • Add Row From Template

Icons group (all ON by default): show or hide each toolbar icon individually:

  • Add Icon

  • Undo Icon

  • Save Icon

  • Refresh Icon

  • Save Template Icon

  • Filter Icon

  • Visible Icon

  • Writeback Icon

Cell Setting card

Setting

Default

Effect

Wrap Text

On

Wraps long cell text (row height capped at 60 px). Turning it off reveals Cell Height.

Cell Height

25

Fixed row height in pixels (when Wrap Text is off)

Padding Top / Bottom / Left / Right

1

Cell padding in pixels

Font Settings

Segoe UI, 10

Cell font family, size (8 to 60) and bold/italic/underline

Text Alignment

Left

Cell text alignment

Text Color

Black

Cell text color

Background Color

White

Cell background color

Column Setting card

Setting

Default

Effect

Font Settings

Segoe UI, 10

Column header font

Text Alignment

Left

Header text alignment

Text Color

Black

Header text color

Background Color

White

Header background color

Disable Action

Off

Hides the column header menu (Edit, Delete, Freeze)

  • Disable Manual Input group: one toggle per field placed in the Dropdown field. When on, that dropdown column only accepts values from the list; users cannot type their own.

API Setting card

See Getting Started with the Table Writeback