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 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.

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.

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 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.

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.

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

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