Skip to main content

Power BI

Needs Votes

Waterfall Chart Breakdown Volume Problem

Vote (24) Share
Michael Swisher's profile image

Michael Swisher on 18 Jul 2017 21:55:10

The charted volume totals for each breakdown when comparing two categories, such as year to year, are the sum of the volumes in both years. They should be the difference between the first year and the second year.

For example, the tool tip correctly displays the first year volume at 482,149 and the second year volume at 592,895, but is displayed as 110.7K on the chart. It should be 592.9k, or just the volume change for that breakdown from the first year to the second year.

If some users need it to work the way it is, could you put a switch to measure only the change between categories as opposed to the total for both categories?

Also, the breakdown needs to be enabled for hierarchies/drilldowns. I will add that as another post.

The waterfall chart is the most useful chart for my company, and you have it to the point that I can almost use it. Thanks for the continuing development.

Comments (3)
Michael Swisher's profile image Profile Picture

on 24 Oct 2024 08:04:12

RE: Waterfall Chart Breakdown Volume Problem

Same here, would love to be able to sort my breakdowns in the order I want.

Michael Swisher's profile image Profile Picture

David de Castro on 16 May 2023 08:02:52

RE: Waterfall Chart Breakdown Volume Problem

Hi there,Yes I support Tony's comment above. Unless I am mistaken then the waterfall breakdown is sorted by values of the breakdown (high to low being the default) as opposed to any column order sorting down at the table level. This type of analysis often calls to show movement in returns from volume or pricing and it would make sense to see these together as opposed the being sorted by the default arrangement.CheersDave

Michael Swisher's profile image Profile Picture

Tony Barrett on 06 Dec 2022 18:46:35

RE: Waterfall Chart Breakdown Volume Problem

Hi,I'd like to be able to do a Custom Sort on the Waterfall Chart breakdown.I'd like it to always show the breakdown in the same order, irrespective of the volume amounts.Kind regards