Let me show you how to create a Table in Power BI with an example. For this table report demonstration, we will use the SQL Data Source that we made in our previous article.
When to use a Power BI Table
- To display the data in a tabular format.
- To view the data at the detailed level.
- To show all the available rows in the given columns.
- If you don’t need a visual representation of data.
- To show more number of numerical column data by categories.
How to Create a Table in Power BI
If you drag and drop any dimension field, then the Power BI desktop 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, the desktop automatically creates a table for you.
You can follow this step if you want to convert the existing chart to a table. 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 Power BI 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 Approach 3
First, click on the shown icon present in the Visualization section. Power BI automatically creates a Table with dummy data, as shown in the below screenshot.
Next, let me drag the English product Subcategory Names and Sales Amounts to the Values section. Now, you can see the actual one with data.
Let me add a few more metric values to tables, such as Total Product Cost, Order Quantity, and Tax amount.
Let me do some quick formatting to this. I suggest you refer to the Format article to understand the formatting options.
A table contains the data arranged in the form of rows and columns. Each row contains detailed low-level information of each column. It may also include the header section and the row totals. Generally, tables help compare multiple fields on a single page. For instance, one or more measures and columns placing side by side.
Selecting the Table icon under the Visualization section within the black page will generate a dummy table. Otherwise, selecting any text field will automatically create a table. Next, add the required fields to the columns section.
Although the basic table looks similar to Excel or any other reporting tool, the formatting options give more power. For instance, add background colors to individual cells, background color, adding data bars, indicators, etc.
There are three types of tables.
1. Physical table – It contains the actual data.
2. Calculated Table or DAX expression table.
3. Virtual table or DAX measure code.