Often you may want to remove the “Total” row from a table in Power BI.
Fortunately this is easy to do and the following example shows how to do so in practice.
Example: How to Remove “Total” Row in Power BI
Suppose we have the following table in Power BI named my_data that contains information about various basketball players:
Suppose that we would like to insert this table into a report in Power BI.
To do so, click the Report view icon on the left side of the screen:
Then click the icon named Table under the Visualizations tab on the right side of the screen:
Then drag the Team, Points and Assists variables all under the Columns label:
This will produce the following table:
Notice that the table contains a Total row at the bottom by default.
To remove this Total row, click the Format your visual tab under Visualizations, then click the Totals dropdown, then toggle the Values to Off:
This will remove the Total row from the bottom of the table:
Note: To remove the Total row from a matrix, follow the same steps but click the dropdown arrow next to Row subtotals instead.
The following tutorials explain how to perform other common tasks in Power BI: