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.
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.
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 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.
Next, let me drag the English product Subcategory Names and Sales Amount to the Values section. Now, you can see the table.
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 Table
NOTE: I suggest you refer to Format a Table article to understand the formatting options.
