Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Miskondukt
Helper III
Helper III

Remove Total Row from Waterfall Chart

Lo again,

 

How do I remove the total row from the waterfall chart? The option provided in this thread (https://community.powerbi.com/t5/Desktop/How-to-remove-the-quot-Total-quot-row/m-p/22990) is no longer available and nor can I find any option to remove from the format opion fields.

 

TY kindly

18 REPLIES 18
KK222222
New Member

KK222222_0-1697700087651.png

 

Ohhh...that's awesome! 

KiantoV
New Member

You need to go to formatting, Y-axis, scroll down and tick off "Show total".

Anonymous
Not applicable

Hi

you could download new visuals (click on the 3 dots to get more visuals) and chose a new waterfall chart.

For my report I used "simple waterfall" chart (see attached image). 

At "define Pillars" turn off "show cumulative Total"キャプチャ.PNG

Hello! it worked perfect to me, thank you!

Anonymous
Not applicable

Is there a solution now to hide the total ?

Nothing that I ever found.

GilesFS
Frequent Visitor

Spoiler
Whilst there isn't currently the facility to turn off the total bar, an easy workaround is to set the colour of the total bar to white (assuming that your graph background is white of course). Not perfect ('Total' label remains) but quick and easy and no scroll bar. Just an idea....
Anonymous
Not applicable

@GilesFS 

The total label still shows and that wasn't acceptable for our customer. 

When we try to hide that we get the scroll bar. 

Unfortunately nothing we did was acceptable for our customer 😞 

Anonymous
Not applicable

Please any update on this...we need this Total to be removed

Has anyone figured this out yet?

Hello friends I found a tricky solution

 

1. go to format X axis 

2. go to Minimum category width And channel the numbers up.

It works like magic  Good luck!

 


Capture.PNGCapture11.PNG








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
Anonymous
Not applicable

@netanel 

If you just change the width you are left with a scroll bar, and that is if you have enough data points that this even works. Is that your experience? 

Unfortunately yes, but there are many alternatives in the Microsoft store we would love to know if you found something to your satisfaction








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
gmaciel
Advocate I
Advocate I

Hope that this topic doesn't get forgotten. Hide the total, or even change its label, would be a very helpful upgrade.

Miskondukt
Helper III
Helper III

Bumpity bump. I also find it quite irregular that the option to remove the total row from this type of chart was once available but now is not? 

I am also looking for that option, which is missing. 


@Miskondukt wrote:

Bumpity bump. I also find it quite irregular that the option to remove the total row from this type of chart was once available but now is not? 


Per my experience, the total for the waterfall chart was never avalibale to hide. You can check this idea Capability to show/hide Total column in Waterfall chart  and vote it up.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors