How to Add Tables in Power BI

Displaying raw data in a clear, organized way is a fundamental part of any report. A Power BI table is the perfect visual for showing detailed information, down to the individual transaction or record. This article will walk you through exactly how to add and customize tables in your Power BI reports, from creating a simple, clean table to using more advanced features like conditional formatting and the matrix visual.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use a Table in Power BI?

While charts are great for visualizing trends and comparisons, sometimes you just need to see the numbers in black and white. Tables are essential when you need to present precise values, compare individual line items, or provide a detailed view that empowers users to look up specific information. They act as the bedrock for many reports, offering a granular level of detail that other visuals summarize.

Think of it this way:

• A bar chart might show you that your sales in the "West" region were the highest last quarter.
• A table can show you every single sale that made up that total - which products were sold, which salesperson closed the deal, and the exact revenue from each transaction.

Tables are also fantastic for data validation. When you're building a dashboard, having a detailed table available lets you double-check that the summarized figures in your charts are accurate.

How to Create a Basic Table: A Step-by-Step Guide

Adding a standard table to your Power BI report is straightforward. It’s a core visualization, perfect for displaying data in a simple row-and-column format. Let's use a common example of sales data to walk through the process.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Open Your Report and Select the Table Visual

First, open your Power BI Desktop file. In the main report view, find the Visualizations pane on the right side of your screen. Look for the icon that looks like a grid - this is the Table visual. Click on it to add an empty table template to your report canvas.

Step 2: Add Data Fields to Your Table

With the new table visual selected, look at the Fields pane, where all your available data sources and columns are listed. To build your table, you simply drag and drop the fields you want to display into the Values well in the Visualizations pane.

For our sales data example, let's add the following fields:

• Product Name: The item that was sold.
• Salesperson: The team member responsible for the sale.
• Region: The geographical area of the sale.
• Order Date: The date the transaction occurred.
• Sale Amount: The revenue from the sale.

As you drag each field into the 'Values' well, you'll see the table on your canvas populate in real-time. Power BI will list every single row from your data source that corresponds to these fields.

Step 3: Organize and Sort Your Columns

Once your data is in the table, you can reorder the columns by clicking and dragging them within the 'Values' well. This allows you to arrange the information in the most logical sequence for your audience.

You can also sort the data by any column. To do this, simply click the header of the column you want to sort by in the table visual itself. Clicking it once will sort it in ascending order (A-Z, lowest to highest), clicking it again will sort it in descending order (Z-A, highest to lowest). An arrow will appear in the column header to indicate the current sort order.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing and Formatting Your Power BI Table

A default table can look a bit plain. Power BI offers a rich set of formatting options to make your tables easier to read, visually appealing, and more insightful. To access these options, select your table and click on the Format (paintbrush) icon in the Visualizations pane.

General Styling and Appearance

Under the 'Visual' tab, you'll find formatting options broken down into categories.

• Style presets: This is a great starting point. You can instantly apply a theme to your table, like 'Minimal', 'Bold header', or 'Alternating rows', which adds color stripes to make rows easier to track across the screen.
• Grid: Here you can customize the horizontal and vertical grid lines. You can change their color, thickness, and style, which helps to separate your data visually. Adding a subtle, light gray border can improve readability without being distracting.
• Values: This section controls the look of the data in the cells. You can adjust the font, text size, color, and background color for all values or alternate rows.
• Column headers: Similarly, you can customize the appearance of your headers. It's common practice to make headers bold and give them a slightly different background color to distinguish them from the data rows.
• Totals: If your table includes numeric data Power BI can aggregate (like 'Sale Amount'), you can toggle on a 'Total' row at the bottom. You can also customize the text and values in this row.

Conditional Formatting: Make Your Data Talk

Conditional formatting is arguably the most powerful feature for tables. Instead of just showing numbers, it uses visual cues like colors, icons, and data bars to highlight important patterns or outliers. This helps your audience grasp insights in seconds without having to read every single number.

To use it, right-click a field in the 'Values' section or find the 'Cell elements' section in the 'Format your visual' pane.

Example: Highlighting Sales Performance

Let's say you want to quickly see which sales were high-value and which were low-value.

1. Select your table, go to the Format your visual pane, and expand the Cell elements section.
2. From the 'Apply settings to series' dropdown, select the numeric column you want to format, such as Sale Amount.
3. Toggle on the Background color option and click the 'fx' button to open the formatting rules.
4. In the pop-up window, you can set rules. For Format style, select Gradient. Power BI will automatically suggest a color scale from lowest to highest value - you can customize the colors to, for example, go from red (lowest) to yellow (middle) to green (highest).
5. Click 'OK'. Now, your Sale Amount column will be color-coded, making it immediately obvious which sales generated the most revenue.

You can also use other conditional formatting types like:

• Data Bars: Adds a small bar chart inside each cell, giving a quick visual comparison of its value relative to others.
• Icons: Adds icons like visual indicators, up/down arrows, or colored circles based on rules you define (e.g., green checkmark for sales above $5,000).

Going Further: Using the Matrix Visual

What if you want to group or aggregate your data in a more structured way, similar to a pivot table in Excel? That's where the Matrix visual comes in. It's right next to the Table visual in the Visualizations pane.

A matrix lets you arrange data by both rows and columns, creating a crosstab where the intersections show aggregated values.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Create a Matrix Visual

1. Select the Matrix visual from the Visualizations pane.
2. Instead of just a 'Values' well, the matrix has three main wells: Rows, Columns, and Values.
3. Drag categorical fields into 'Rows' and 'Columns'. For example, drag 'Region' to the 'Rows' well and 'Product Category' to the 'Columns' well.
4. Drag a numeric field to 'Values'. For this example, drag 'Sale Amount' into 'Values'. Power BI automatically creates a summary table showing total sales for each product category within each region.

The real power of a matrix is its drill-down capabilities. If you add multiple fields to the 'Rows' well (e.g., 'Region' then 'Salesperson' underneath it), you can expand and collapse categories to see different levels of detail. Icons for drilling down (such as a plus sign) will appear next to the row headers, giving users an interactive way to explore the data.

Final Thoughts

Creating tables in Power BI is a core skill for any analyst or report builder. Whether you're using a simple table for detailed lookups or a matrix to show summarized, hierarchical data, these visuals provide clarity and depth to your reports. By mastering the formatting tools - especially conditional formatting - you can transform rows of numbers into compelling stories that are easy for anyone to understand.

Building reports in tools like Power BI is incredibly powerful, but often requires hours of clicking, configuring, and learning a complex interface. We built Graphed to remove that friction completely. Instead of dragging and dropping fields, you can just ask in plain English: "Show me a table of our top products by sales amount in the West region this quarter," and the visualization is created for you instantly. By connecting all your data sources into one place, we help teams get answers and build real-time dashboards in seconds, not hours.