In this article we will show you, How to Create a Table in Power BI with example. For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Table in Power BI
If you drag and drop any dimension field then Power Bi will automatically create a table for you. Let me drag and drop the English Product Name from Fields section to Canvas. As you can see from the below screenshot, Power BI is automatically creating a table for you.
Create a Table in Power BI – Approach 2
If you want to convert existing chart to table then you can follow this step. As you can see from the below screenshot, we created a column chart, which represent the Sales Amount by Product Name.
Click on the Table under the Visualization section. This will automatically convert 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 under the Visualization section. This will automatically create a Table with dummy data as shown in 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 to refer Format a Table article to understand the formatting options.
Thank You for Visiting Our Blog