How to Insert Table in Power BI

Displaying raw data in a clear, organized format is one of the most fundamental tasks in any report. Power BI gives you a way to do exactly that with its versatile table visual. A well-formatted table can present detailed information at a glance, making it a cornerstone for many dashboards.

Graphed

Still Building Reports Manually?

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

Watch the Demo

This tutorial will walk you through everything you need to know about creating, formatting, and customizing tables in Power BI. We'll cover the basic steps for inserting a table and dive into the specific formatting options that will make your data readable and professional.

Why Use a Table Visual in Power BI?

With so many "flashy" visuals like waterfall charts and donut graphs, a simple table might seem boring. However, it's often the most effective tool for the job. Tables are perfect when you need to:

• Show Detailed Information: Tables display data at the row level, allowing users to see individual records and their specific attributes. This is perfect for things like order history, contact lists, or product catalogs.
• Provide Precise Values: While a bar chart is great for comparing magnitudes, a table gives you the exact numbers. When stakeholders need specifics, a table is the answer.
• Compare Multiple Metrics for an Item: You can easily display several related metrics for a single item in one row. For example, a single row could show a product's name, category, warehouse location, units sold, and total revenue.

In short, when the goal is to present organized, detailed data for review rather than visualizing high-level trends, the table visual is your best friend.

Step-by-Step Guide: How to Insert a Table in Power BI

Dropping a table onto your Power BI report is straightforward. For this example, let's assume you've already connected to a data source (like an Excel file or a database) containing sales information.

1. Select the Table Visual

First, open your report in Power BI Desktop. In the Visualizations pane on the right-hand side, find and click on the icon that looks like a grid. This is the Table visual. Clicking it will add a blank table placeholder to your report canvas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Add Data to Your Table

With the blank table visual selected, look at your Data pane (typically located to the right of the Visualizations pane). Here you'll see all the tables and fields from your data model.

To add columns to your table, simply drag the fields you want from the Data pane and drop them into the Columns field well under the Visualizations pane. Alternatively, you can just check the box next to the field name in the Data pane.

For a sales report, you might drag over fields like:

• Product Name
• Sales Rep
• Region
• Units Sold
• Revenue

As you add each field, a corresponding column will appear in the table on your canvas, automatically populated with data.

3. Adjust and Resize

Your table is now live on the report canvas. You can click and drag the corners or edges to resize it. You can also adjust the width of individual columns by hovering your mouse over the border between column headers until the cursor changes, then clicking and dragging.

Formatting Your Power BI Table for Clarity

Creating the table is the easy part, making it look professional and easy to read is next. Power BI offers a rich set of formatting options. Select your table, then click the Format your visual icon (it looks like a paintbrush) in the Visualizations pane.

Let's go through the most useful formatting options.

Style Presets

The quickest way to apply a consistent design is by using a style preset. Under the "Visual" tab in the formatting options, the first setting is Style presets. You can choose from options like:

• Minimal: A clean, basic look.
• Alternating rows: Shades every other row to improve readability, much like in Excel.
• Bold header: Makes the column titles stand out.
• Flashy rows: A high-contrast style that makes data pop.

Selecting a preset is a great starting point, and you can always customize it further.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Grid, Borders, and Spacing

To fine-tune the table's structure, you can adjust the gridlines.

• Horizontal and Vertical Gridlines: You can enable or disable these with a toggle. Turning on horizontal gridlines and a subtle vertical grid is often best for readability.
• Grid Color and Width: Use a light gray for the gridlines to provide structure without distracting from the data.
• Row Padding: Increasing the row padding slightly can give your data more breathing room and make the table feel less cramped.

Column Headers and Values

You have separate controls for the table headers and the data values themselves.

In the Column headers section, you can:

• Change the text font, size, and color (e.g., Bold, 12pt, Dark Blue).
• Set a background color for the header row to make it distinct.
• Adjust text alignment (left, center, or right for each header).
• Turn on Word wrap if you have long column titles.

In the Values section, you can format the data rows:

• Adjust the text font, size, and color for all the data.
• Set background colors for both the primary and alternate rows if you've enabled "Alternating rows."

Totals Row

For tables with numeric data, adding a totals row is incredibly useful. In the formatting options, find the Totals section and toggle it on. Power BI will automatically calculate and display the sum for any numeric columns in your table. You can also format the text, font, and background color of the totals row to distinguish it from the rest of the data.

Advanced Table Techniques in Power BI

Once you've mastered the basics, you can use these features to add another layer of insight to your tables.

Conditional Formatting

Conditional formatting turns your table from a passive list into an analytical tool. It allows you to automatically change a cell's appearance based on its value.

To set it up:

1. Under the "Visual" tab of the formatting pane, expand the Cell elements section.
2. Choose the column you want to format from the dropdown (e.g., Revenue).
3. Toggle on one of the formatting options: Background color, Font color, Data bars, or Icons.
4. Click the f(x) icon to define your rules. For example, you can set the background color to turn green for revenue above a certain threshold and red for revenue below it.

This simple visual cue helps users instantly spot high-performing and low-performing items without having to read every single number.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Table vs. Matrix: What's the Difference?

A common point of confusion for new Power BI users is the difference between a table and a matrix. While they look similar, their purpose is distinct.

• Table: Use a table for a flat, two-dimensional view. It displays data in simple rows and columns, perfect for lists and detailed records where each row is a unique item.
• Matrix: Use a matrix when you need to group and summarize data across multiple dimensions, much like a pivot table in Excel. A matrix can have values grouped by both rows and columns (e.g., showing Sales by Region down the rows and by Year across the columns).

If you find yourself wanting to "group" rows, you probably need a matrix instead of a table.

Sorting Your Table Data

By default, users can sort the table on the report by clicking any column header. One click sorts a column in ascending order, and a second click sorts it in descending order. You can also specify a default sort order. With the visual selected, click the ellipsis (...) in the top-right corner, go to "Sort by," and choose the column you want to be the default sort key.

Final Thoughts

Mastering the table visual is an essential Power BI skill. It allows you to present detailed, structured data that underpins the high-level insights from your charts and graphs. By using the rich formatting and conditional options available, you can transform a simple grid of numbers into a clear and compelling part of your reporting story.

And while Power BI is an incredibly robust tool for deep analysis, we know that building reports and pulling together all your data can still be a manual chore. At Graphed, we streamline this entire process. Instead of navigating menus and formatting panes, you can connect your sources - like Google Analytics, Shopify, and Salesforce - and simply ask for what you need in plain English. We turn your request into a live, professional dashboard in seconds, letting you get straight to the insights without all the busywork in between.