Power BI: How to Remove “Total” Row from Table


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:

Power BI remove total from table

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.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Remove Blank Rows in Power BI
How to Remove Duplicates in Power BI
How to Remove Column Headers in Table in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *