How To Add Total In Power Bi Table

In Power BI, you can add a total row to a table by enabling the “Total Row” option. Here’s how you can do it:

1. Open your Power BI report and select the table visualization you want to add the total row to.
2. In the “Visualizations” pane, click on the small “Format” icon (paint roller).
3. In the “Formatting” options, scroll down to find the “Total Row” option. Enable it by toggling the switch to the “On” position.
4. Once the total row is enabled, you can choose the aggregation function for each column you want to include in the total. Click on the drop-down menu for each column and select the desired aggregation function (e.g., sum, average, count, etc.).
5. The total row will automatically appear at the bottom of the table, showing the calculated value for each selected column based on the chosen aggregation function.

Here’s an example to illustrate the process. Suppose you have a table showing sales data with columns “Product Name” and “Quantity Sold”. You want to add a total row that displays the sum of the quantities sold. Follow the steps outlined above to achieve this.

In the example above, the total row is added with the sum of the quantities sold. You can customize the table and add more columns or aggregation functions as per your requirements.