How To Add Total Row In Power Bi Table

How to Add Total Row in Power BI Table

In Power BI, you can add a total row to a table by using the “Total Row” feature. This feature allows you to display the sum, average, minimum, maximum, or other calculations of a column directly in the table.

To add a total row in Power BI, follow these steps:

1. Select the table visual in your report.
2. In the “Visualizations” pane on the right side, click on the “Table” icon to open the table settings.
3. In the “Column tools” section of the table settings, enable the “Total” option by clicking on the toggle switch.
4. Once the “Total” option is enabled, you will see a new row at the bottom of the table labeled “Total”.
5. Choose the desired aggregation function from the drop-down menu in the “Total” row. For example, select “Sum” to display the sum of values in the respective column.

Here’s an example to illustrate the process:

In this example, the “Total” row displays the sum of quantities from the “Quantity” column.

You can further customize the total row by applying formatting, such as bold text or different background color, to make it stand out in the table.