Power BI

Needs Votes

Sort by breakdown in Waterfall

Vote (232)

on 01 Feb 2018 04:21:18

Waterfall in July 2017 update is cool. But it is looking really weird when the breakdown dimension is a period (ie. months that have a natural order). It would be great if the chart could be sorted by Breakdown dimension. On the example of months, we will be able to see the variation between 2 years by month in the right natural order (Jan, Feb, Mar, ...) instead of by value variation that is dificult to interprete

More details here:
https://community.powerbi.com/t5/Issues/Sorting-on-breakdown-attribue-of-waterfall-chart-not-working/idc-p/349280#M21430

Comments (28)

Comments (28)

Dylan Han on 18 Aug 2020 08:46:20

RE: Sort by breakdown in Waterfall

This functionality is definitely needed.

Where you have a perpetual waterfall, it only makes sense to have the categories in a fixed order.

Søren Pedersen on 06 Jul 2020 00:17:39

RE: Sort by breakdown in Waterfall

Please implement this feature, it is extremely important for intuitive understanding of the charts

Jeanne Nymeyer on 06 Jul 2020 00:17:08

RE: Sort by breakdown in Waterfall

I would love to see this feature as well. Not being able to sort by the breakdown (period, quarter, etc) is very frustrating.

Shoaib Ahmed Khan on 06 Jul 2020 00:16:23

RE: Sort by breakdown in Waterfall

Please any update here. It's a very basic feature. For example, I can't do a YOY change breakdown by month. Months are sorted in descending order green to red.
And we can't make a sense out of it months being not naturally sorted Jan to Dec.

bram on 06 Jul 2020 00:14:16

RE: Sort by breakdown in Waterfall

Pleas add this feature

Valerie Oguz on 06 Jul 2020 00:13:26

RE: Sort by breakdown in Waterfall

this feature is a must to have. Please implement it

Vazgen on 06 Jul 2020 00:10:46

RE: Sort by breakdown in Waterfall

Incredible, such a basic thing is missing. This is just a must have.

Mac on 06 Jul 2020 00:09:40

RE: Sort by breakdown in Waterfall

Please implement sort by breakdown

Dave on 06 Jul 2020 00:09:05

RE: Sort by breakdown in Waterfall

Not being able to use a sort by breakdown option is very frustrating. For our organization it renders that visual completely useless. If we want to put YTD Sales on the Y Axis, the Year in the Category and then the Region in the Breakdown - the sorting we have on the Region does not work in the Breakdown, which renders this visual completely obsolete and should be removed from Power BI as a whole.

Matteo on 06 Jul 2020 00:02:53

RE: Sort by breakdown in Waterfall

besides the example in the description I 'd like to sort the BREAKDOWN by any measure, not just the one I have in Y AXIS.