Skip to main content

Power BI

New

Waterfall Chart Breakdown Volume Problem

Vote (6) 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.