Skip to main content

How to Add a Table to a Power BI Report

· 4 min read
Jagdish Kumawat
Founder @ Dewiride

Cards and charts summarise; a table shows the rows behind them. The table visual lists the columns you tick, one row per combination of values, with a total at the bottom. Here's how to add one.

Microsoft's Create and format table visualizations covers the table visual and its formatting. The example lists the claims of an Expenses table: Expense, Amount, Category and ExpenseDate.

Step 1: Select the Table Icon​

In the report, in Editing mode, click an empty part of the page so nothing is selected, then select the Table icon in the Visualizations pane:

The Visualizations pane's icons with the Table icon, a plain grid, outlined in red

Step 2: Tick the Columns​

In the Data pane, tick the columns in the order you want them, here Expense, Amount, Category and ExpenseDate. They go into the Columns well:

The Columns well with Expense, Sum of Amount, Category and ExpenseDate

Amount became Sum of Amount: Power BI adds up number columns. In the example, ExpenseDate first came in as Year, Quarter, Month and Day, and had to be switched back to the date itself (Fixed: Power BI Table Shows Year, Quarter, Month and Day Instead of the Date).

Step 3: Check the Table​

The table lists the five claims with a Total row at the bottom:

A table with the columns Expense, Sum of Amount, Category and ExpenseDate, the rows Client dinner, Hotel room, Printer ink, Taxi and Train ticket, and a Total row of 293.70

The header Sum of Amount can say just Amount (How to Rename a Field in One Power BI Visual).

A table shows one row per combination of values. Two claims with the same description, amount, category and date would show as one row with their amounts added up; add a column that tells them apart if each must show.

Common Mistakes​

MistakeWhat happensDo this instead
Ticking the columns with another visual selectedThe columns go into that visualClick an empty part of the page first
Expecting every row to showIdentical rows are groupedAdd a distinguishing column
Leaving the date as a hierarchyYear, quarter, month and day columnsChoose the date itself in the well's menu

Troubleshooting​

SymptomLikely causeFix
Sum of in a headerA number column is summedRename it for the visual
Year, Quarter, Month and Day columnsThe date came in as its hierarchyChoose the date in the well's menu
A scrollbarMore rows than the visual's heightMake it taller, or let it scroll

FAQ​

Can I sort the table?​

Yes: select a column header to sort by it.

Can a table show a measure?​

Yes: tick the measure like a column. It's worked out for each row and for the total.

Conclusion​

Select the Table icon and tick the columns in order. Power BI sums number columns and adds a total; the example listed five claims with a total of 293.70.

Additional Resources​