Remove Total Row from Waterfall Chart

[Miskondukt]

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

[KK222222]

[Cali_2020]

Ohhh...that's awesome! 

[KiantoV]

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

[Anonymous]

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"

[janainacarmo]

Hello! it worked perfect to me, thank you!

[Anonymous]

Is there a solution now to hide the total ?

[Cali_2020]

Nothing that I ever found.

[GilesFS]

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]

@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]

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

[Cali_2020]

Has anyone figured this out yet?

[netanel]

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!

[Anonymous]

@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? 

[netanel]

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

[gmaciel]

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

[Miskondukt]

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? 

[thapaliya233]

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

[Eric_Zhang]

---

@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.