cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GD61 Member
Member

How to remove the "Total" row

Hi,

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

Thanks

 

Total row.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: How to remove the "Total" row

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Phil_Seamark Super Contributor
Super Contributor

Re: How to remove the "Total" row

totals.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

7 REPLIES 7
Phil_Seamark Super Contributor
Super Contributor

Re: How to remove the "Total" row

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Phil_Seamark Super Contributor
Super Contributor

Re: How to remove the "Total" row

totals.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

GD61 Member
Member

Re: How to remove the "Total" row

Thanks a lot !

sriharsha36 Frequent Visitor
Frequent Visitor

Re: How to remove the "Total" row

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. 

klabir
Advisor

Re: How to remove the "Total" row

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

M8.PNG

megm001 Regular Visitor
Regular Visitor

Re: How to remove the "Total" row

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

Seaman Visitor
Visitor

Re: How to remove the "Total" row

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,

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 366 members 4,016 guests
Please welcome our newest community members: