Create a Table in Power BI

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

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

How to Create a Table in Power BI

If you drag and drop any dimension field, then Power BI 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, desktop automatically creating a table for you.

Create a Table in Power BI 1

Creating a Table Approach 2

If you want to convert the existing chart to the table, then you can follow this step. As you can see from the screenshot below, we created a column chart, which represents the Sales Amount by Product Name.

Create a Table in Power BI 2

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

Create a Table in Power BI 3

Create a Table in Power BI Approach 3

First, click on the Table present in the Visualization section. It 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 Amount to the Values section. Now, you can see the table.

Create a Table in Power BI 5

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

Create a Table in Power BI 6

Let me do some quick formatting to this Table

NOTE: I suggest you refer to Format a Table article to understand the formatting options.

Create a Table in Power BI 8

Comments are closed.