WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
September 2021 Power BI Update
Part five of a seven-part series of blogs

The September 2021 update to Power BI introduces even more features for customising buttons, a Power Automate connector and line chart series labels, along with a few other small changes.

  1. September 2021 Power BI Update
  2. You can use shapes and icons as buttons
  3. Running Power Automate flows from Power BI reports
  4. You can now label line chart series
  5. Suppressing totals on waterfall charts (this blog)
  6. Changes to DAX
  7. Pictorial histograms using the Graphomate custom visual

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 28 September 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppressing totals on waterfall charts

This is a niche feature of a niche chart type!

A waterfall chart

A standard waterfall chart shows a breakdown of figures into different categories.

However, if you use a breakdown as shown above you don't get a total column, so this feature only applies to waterfall charts without breakdowns:

A waterfall chart with no breakdown

A waterfall chart with no breakdown.

You can now suppress the total bar on the Y axis formatting card:

Suppressing total

Toggle this option off to suppress the waterfall chart total.


Here's the result of the above change:

No total bar

The total bar has disappeared.

Apparently Microsoft have made this change in response to feedback, but I don't think it would have been my number one waterfall chart change request!

This blog has 0 threads Add post