Power BI Table

Let me show you how to create a Table in Power BI with an example. For this table report demonstration, we will use the SQL Data Source that we made in our previous article.

Please refer to Connect to SQL Server article to understand the Power BI Data Source.

When to use a Power BI Table

  • To display the data in a tabular format.
  • To view the data at the detailed level.
  • To show all the available rows in the given columns.
  • If you don’t need a visual representation of data.
  • To show more number of numerical column data by categories.

How to Create a Table in Power BI

If you drag and drop any dimension field, then the Power BI desktop automatically creates a table for you.

Let me drag and drop the English Product Name from the Fields section to Canvas. As you can see from the screenshot below, the desktop automatically creates a table for you.

Add Fields to Values and Visual Level Filters 1

Method 2

You can follow this step if you want to convert the existing chart to a table. We created a column chart, which represents the Sales Amount by Product Name.

Create a Table in Power BI 2

Click on the shown button under the Visualization section. It automatically converts the Power BI Column Chart into a Table. From the below screenshot, you can see the Tabular representation of Product names and their Sales Amount.

Add Measure and Dimension to Values 3

Create a Table Approach 3

First, click on the shown icon present in the Visualization section. Power BI automatically creates a Table with dummy data, as shown in the below screenshot.

Create a Table in Power BI 4

Next, let me drag the English product Subcategory Names and Sales Amounts to the Values section. Now, you can see the actual one with data.

Add Fields to Values 5

Let me add a few more metric values to tables, such as Total Product Cost, Order Quantity, and Tax amount.

Add Multiple Measure Fields to Values 6

Let me do some quick formatting to this. I suggest you refer to the Format article to understand the formatting options.

Create a Table in Power BI 8

Table FAQ’s

What is Power BI Table?

A table contains the data arranged in the form of rows and columns. Each row contains detailed low-level information of each column. It may also include the header section and the row totals. Generally, tables help compare multiple fields on a single page. For instance, one or more measures and columns placing side by side.

How do you create a table in Power BI?

Selecting the Table icon under the Visualization section within the black page will generate a dummy table. Otherwise, selecting any text field will automatically create a table. Next, add the required fields to the columns section.

Is Power BI good for tables?

Although the basic table looks similar to Excel or any other reporting tool, the formatting options give more power. For instance, add background colors to individual cells, background color, adding data bars, indicators, etc.

What are the types of tables in Power BI?

There are three types of tables.
1. Physical table – It contains the actual data.
2. Calculated Table or DAX expression table.
3. Virtual table or DAX measure code.

Comments are closed.