Skip to main content

    Power BI

    New

    Sort by breakdown in Waterfall

    Vote (112) Share
    's profile image

    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 (19)
    's profile image Profile Picture

    17e76c1e 57ca-ea11-a813-000d3a579c38 on 09 Sep 2020 08:00:57

    RE: Sort by breakdown in Waterfall

    That's weird. offering a buggy version of chart and forcing users to use it in wrong way.

    's profile image Profile Picture

    e58ae6ac 2de1-ea11-a813-000d3a563be2 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 profile image Profile Picture

    beea07fa df71-483c-bc9f-8d87e8cb0852 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

    's profile image Profile Picture

    2519ca42 0fd5-4bd4-a9ee-7329acef2593 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.

    's profile image Profile Picture

    b548bbf9 9721-4e68-8cdf-259b870f3629 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.

    's profile image Profile Picture

    900f2836 71ff-43d0-9e43-b6962f40cbe2 on 06 Jul 2020 00:14:16

    RE: Sort by breakdown in Waterfall

    Pleas add this feature

    's profile image Profile Picture

    571b7135 60df-4fdc-9436-697def133b53 on 06 Jul 2020 00:13:26

    RE: Sort by breakdown in Waterfall

    this feature is a must to have. Please implement it

    's profile image Profile Picture

    fee824df 0a10-44c0-8063-919b2c320bcc 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.

    's profile image Profile Picture

    6e37dff4 f9ec-46dc-beee-54c0f6431c2d on 06 Jul 2020 00:09:40

    RE: Sort by breakdown in Waterfall

    Please implement sort by breakdown

    's profile image Profile Picture

    40062fad 35f5-4b9e-beab-e5f7da94304e 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.