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

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

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

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

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?

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.

Remove Total Row from Waterfall Chart | Microsoft Fabric Community

18 Replies

Anonymous
Not applicable
7 years ago
Hope that this topic doesn't get forgotten. Hide the total, or even change its label, would be a very helpful upgrade.
Anonymous
Not applicable
6 years ago
Please any update on this...we need this Total to be removed
- Cali_2020
  Helper I
  6 years ago
  Has anyone figured this out yet?
  - netanel
    Post Prodigy
    6 years ago
    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!
Miskondukt
Helper III
9 years ago
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
  Regular Visitor
  7 years ago
  I am also looking for that option, which is missing.
- Eric_Zhang
  Microsoft Employee
  9 years ago
  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.
Anonymous
Not applicable
5 years ago
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
  Regular Visitor
  5 years ago
  Hello! it worked perfect to me, thank you!
KK222222
Regular Visitor
2 years ago
- Cali_2020
  Helper I
  2 years ago
  Ohhh...that's awesome!
GilesFS
Frequent Visitor
6 years ago
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
  6 years ago
  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
5 years ago
Is there a solution now to hide the total ?
- Cali_2020
  Helper I
  5 years ago
  Nothing that I ever found.
Anonymous
Not applicable
4 years ago
You need to go to formatting, Y-axis, scroll down and tick off "Show total".

Forum Discussion

Remove Total Row from Waterfall Chart

18 Replies

Related content

Waterfall Charts with running totals

Waterfall Chart - Totals seen as increases and not totals

Waterfall Chart - Set as total

Remove line on waterfall chart

Waterfall Chart