How to remove the "Total" row

[GD61]

Hi,

How to remove the "Total" row at the bottom of the Table report:

Thanks

[Phil_Seamark · Accepted solution]

If you click on the table visual to give it focus, then click the format paint brush you can find the option to turn totals on/off under the general area.

[Anonymous]

For some reason, Total is not coming up anywhere mentioned and keeps coming in the visuals. Version: 2.88.1144.0 64-bit (December 2020). Not sure it's a bug or something I am missing here. 

[Anonymous]

In the 2018 version, select the Matrix, go to the Paintbrush, look for the "Subtotals" section.  You will find toggle switches for both rows and columns.

Regards,

[sriharsha36]

Go into the Fields Icon , which is on the Right End ( which is more of a Rectangle inside a Rectangle Shape). Right Click on the filed which you do not want the total for "Check"/ "Select" the "Dont Summarize" option. 

[megm001]

@sriharsha36I don't see the "Don't Summarize" option for my two calculated measures. Do I need to do that elsewhere?

[klabir]

if you need to remove the totals in a waterfall chart or if you need a different staring value in a power bi custum visual, take a look at the Power BI Ultimate Waterfall Chart, download it here:

http://dataviz.boutique/2017/03/22/powerbi-ultimate-waterfall-custom-visual/

BR

Klaus

[Phil_Seamark · Accepted solution]

If you click on the table visual to give it focus, then click the format paint brush you can find the option to turn totals on/off under the general area.

[Anonymous]

Hi, Just go to format visual, find "Totals" and turn off values 🙂

[PaulMac]

**This answer is now out of date**

To remove the 'Totals' row from a table in Version: 2.76.5678.782 (December 2019) of Power BI, do the following:

1. Select the table you want to remove the totals row on
2. In the 'Visualizations' pane, click the 'Format' button (looks like a paint roller)
3. Go down and find 'Subtotals'
4. Under 'Row subtotals', switch to off

Done! 😁

[Phil_Seamark · Accepted solution]

[inservo]

What "UX Expert" within Microsoft made this not work anymore? Now if I have a table even with the totals turned off, I have totals. Do you guys ever test stuff, before you release it?

See screenshot:

[GD61]

Thanks a lot !