Create a Table in Power BI

Let me show you how to create a Table in Power BI with an example. For this Power BI 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.

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.

Add Fields to Table Values and Visual Level Filters 1

Method 2

If you want to convert the existing chart to the table, then you can follow this step. 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 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 shown icon present in the Visualization section. It automatically creates a Table with dummy data, as shown in the below screenshot.

Create a Table 4

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

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. I suggest you refer to Format article to understand the formatting options.

Create a Table in Power BI 8

Comments are closed.