How to Create Table Visualization in Power BI

Tables are the unsung heroes of data reporting. While bar charts grab the attention and line charts tell a story over time, a clean, well-structured table provides the bedrock of detail for any dashboard. This guide will walk you through exactly how to create, format, and enhance table visualizations in Power BI, step-by-step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Why Use a Table Visualization?

In a world of dynamic charts and flashy visuals, an old-school table might seem a bit Plain-Jane. However, tables serve a function that other visuals can't. They are perfect when you need to see precise values and compare multiple, related data points for individual items.

Think about these scenarios:

• Reviewing individual sales transactions.
• Comparing multiple metrics for a specific product (e.g., Sales, Profit, Units Sold, and Inventory).
• Displaying a list of contacts with their associated company and title.

While a bar chart is great for comparing a single metric across categories, a table lets you see all the supporting details in one organized view. It’s the closest you can get to viewing your raw spreadsheet data directly within your report, but with all the filtering and formatting power of Power BI.

Step 1: Get Your Data into Power BI

Before you can build anything, you need some raw materials. For this tutorial, we'll assume you have a simple sales dataset in an Excel or CSV file with columns like Product Name, Category, Region, Sale Date, Units Sold, and Revenue.

If you don’t have data yet, here’s how to pull it in:

1. On the Home tab in Power BI Desktop, click Get data.
2. Select the appropriate source. For this example, choose Excel workbook or Text/CSV.
3. Navigate to your file, select it, and click Open.
4. A navigator window will pop up. Check the box next to the sheet or data table you want to import.
5. You'll see a preview. Click the Load button to bring the data directly into your Power BI model. For more advanced cleaning, you would use Transform Data, but for now, Load is perfect.

Once loaded, you’ll see your data fields listed in the Data pane on the right side of the screen.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Create a Basic Table Visualization

With your data ready to go, creating the table is surprisingly simple. You're just a few clicks and drags away.

1. Select the Table Visual

In the Visualizations pane (it’s next to the Data pane), find and click the icon that looks like a grid. This is the Table icon. Clicking it will place a blank, empty table template onto your report canvas.

2. Add Data Fields

Now, it's time to populate your table. With the empty table visual selected on your canvas, look over at your Data pane. Here’s how you add data:

• Find the fields you want. For our example, let's find Product Name, Category, Units Sold, and Revenue.
• Drag and drop. Click and drag each field from the Data pane over to the Values well under the Visualizations pane. Alternatively, you can simply check the box next to each field name.

As you add fields, Power BI will instantly build the table on your canvas. Power BI is smart enough to recognize text fields (like Product Name) as dimensions and numeric fields (like Revenue) as measures, automatically summing them up if appropriate. You should now see a table with four columns, listing all your products and their corresponding metrics.

Step 3: Formatting Your Table for Readability

A raw table gets the job done, but a well-formatted table communicates information effectively. Let's make it look professional and easy to read.

Make sure your table is selected, then click the icon that looks like a paintbrush (Format your visual) in the Visualizations pane. This opens up a world of formatting options.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Styling Basics

• Style presets: Under the Format tab in the formatting options, the very first option is Style presets. This dropdown gives you quick themes like "Minimal," "Bold header," and "Alternating rows," which can dramatically improve readability with one click.
• Grid lines: Toggle vertical and horizontal grid lines, change their color, and adjust their thickness to better define your rows and columns.
• Column headers: Change the font, size, color, and background of your headers. Making them bold and giving them a subtle background color helps them stand out.
• Values: This section controls the formatting for the data cells themselves. You can adjust the font and colors here, including setting a different color for alternating rows if you didn't use a preset.
• Totals: Power BI automatically adds a "Total" row for numeric columns. You can toggle this on or off, and format its font, and background distinctly from the rest of the table.

Resizing and Rearranging Columns

You don't need a menu for everything. Some formatting is done directly on the visual itself:

• To resize a column, hover your mouse over the border of the column header until the cursor changes to a double arrow, then click and drag.
• To rearrange columns, click and hold on a column header, then drag it left or right to its new position.

Step 4: Supercharge Your Table with Advanced Features

Now that your table looks good, let's make it more insightful. These features turn your table from a static data list into an interactive analytical tool.

Conditional Formatting

Conditional formatting helps you spot trends and outliers instantly by adding color, bars, or icons to your data based on rules you set. This is one of the most powerful features for tables.

Let's say you want to highlight high-revenue products in green. Here's how:

1. In the Visualizations pane, go to the Values well where you dropped your fields.
2. Right-click on the Revenue field and select Conditional formatting.
3. Choose an option like Background color or Data bars.

Let's use Background color. A new window will appear.

• Format style: You can choose "Gradient" to automatically apply colors from low to high, or "Rules" for more specific conditions.
• Using the default Gradient, Power BI will suggest a color scale where lower values are a light shade and higher values are a darker shade. You can customize these colors.
• Click OK.

Instantly, your Revenue column is now color-coded, making it easy to see top-performing products at a glance. You can do the same for Units Sold with data bars to create an in-cell bar chart, which is fantastic for quick visual comparison.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Adding a Measure with DAX

Sometimes the data you need isn't in your source file. For example, what if you want to see Average Revenue per Unit? You can create this with a DAX (Data Analysis Expressions) formula.

1. On the Home ribbon, click New measure.
2. The formula bar will appear. Type in your formula. For our example, it would be:

Avg Revenue per Unit = DIVIDE(SUM(Sales[Revenue]), SUM(Sales[Units Sold]))

1. Press Enter. A new measure with a calculator icon will appear in your Data pane.
2. Drag this new measure into your table just like any other field. Voila! You have a new, calculated column in your analysis.

Quick Tips for Effective Tables

• Don't Overload it: Tables are for detail, but too many columns become overwhelming. If you have more than 7-10 columns, consider if they are all necessary or if you could split them into multiple tables or use a matrix visual instead.
• Use Clear Names: You can rename columns directly in the Columns well by double-clicking them. Change unfriendly database names like fact_revenue_usd to something simple and clear, like "Revenue."
• Right-Align Numbers: It's a standard practice that makes it much easier to compare numbers. Power BI usually does this by default, but you can change alignment in the format options under 'Specific column'.
• Pair with Other Visuals: Tables work best as part of a dashboard. Use a bar chart to show top-level trends and allow users to click on it to filter the table, providing them with the underlying details.

Final Thoughts

Creating a table in Power BI is a fundamental skill, taking you from raw data to a formatted, insightful visual in just a few steps. By mastering the basics of creation, formatting, and a few advanced features like conditional formatting, you can build powerful, detailed reports that clearly communicate the story your data is telling.

Building reports in tools like Power BI is incredibly valuable, but we know it can come with a steep learning curve that requires hours of learning and manual configuration. We believe getting insights shouldn't be that complicated, which is why we built Graphed. Instead of navigating formatting panes and clicking through menus, you can connect your data sources and then create tables, charts, and entire dashboards just by asking in simple English. It allows you to skip straight to the answer without getting bogged down in the process of building the report.