Skip to main content

    Power BI

    Planned

    Custom order for legend

    Vote (5174) Share
    Krishna Sankar's profile image

    Krishna Sankar on 30 Jul 2015 05:43:14

    I should be able to order the "legend" and the values for each legend category in a stacked bar chart. This is similar to "series order" feature in Excel

    Administrator on 18 Oct 2022 00:54:14

    Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo

    Thanks for the feedback. Vote to keep updated on progress for this item.

    Comments (344)
    Krishna Sankar's profile image Profile Picture

    Huan Wang on 16 Aug 2020 03:58:01

    RE: Custom order for legend

    this is the standard way to look at the data folks ~!

    Krishna Sankar's profile image Profile Picture

    James Winegar on 16 Aug 2020 03:57:49

    RE: Custom order for legend

    This is one of the items stopping me from switching to Power BI

    Krishna Sankar's profile image Profile Picture

    Stuart Charles on 16 Aug 2020 03:57:49

    RE: Custom order for legend

    Come on Power BI team - this is very basic missing functionality!

    We need to be able to stack Revenue in a given week, but we want the recognised revenue at the bottom and forecast at the top.

    Krishna Sankar's profile image Profile Picture

    Niels on 16 Aug 2020 03:57:37

    RE: Custom order for legend

    Visuals should have a custom sort option on multiple columns. Sometimes I want to decide how to sort data and not use natural sorting.

    Krishna Sankar's profile image Profile Picture

    Sebastian Sim on 16 Aug 2020 03:56:34

    RE: Custom order for legend

    I am doing a NPS report and will be good to do a leaderboard sort by NPS then RR.

    Krishna Sankar's profile image Profile Picture

    Teodoro on 16 Aug 2020 03:56:26

    RE: Custom order for legend

    Use multiple columns to enhance the functionality "sort by" of "slicers" in Power BI by adding the possibility to "sort by other non visible columns".

    E.g.
    Column "month": jan, feb, mar, ... (visible in the slicer)
    Column "month number": 1, 2, 3, ... (used to sort the visible fields in the slicer)

    Krishna Sankar's profile image Profile Picture

    BG on 16 Aug 2020 03:56:23

    RE: Custom order for legend

    Having a legend order matching the stacked bars value is a charting 101 issue. It has been Excel for decades. Please add this basic feature ASAP.

    Thanks...

    Krishna Sankar's profile image Profile Picture

    raynok on 16 Aug 2020 03:56:04

    RE: Custom order for legend

    Would be great, my example . . . .

    Either using the stacked column chart or clustered I would like to sort the following

    1.) showing by months
    2.) Total (sum) of categories, 8 different categories
    3.) X-axis concatenate labels turn off

    Issue: As soon as I try sorting the Total( sum) category by (Asc) the x-axis concatenate turn off option breaks.

    In excel it works, I would like to see this working in power bi desktop/services

    Again, would be great.

    Krishna Sankar's profile image Profile Picture

    ML on 16 Aug 2020 03:55:50

    RE: Custom order for legend

    why isn't this a thing yet? incredibly frustrating to have to come up with work-arounds for something so basic!

    Krishna Sankar's profile image Profile Picture

    TS on 16 Aug 2020 03:55:14

    RE: Custom order for legend

    My short example why "Custom Sort Lists" (like in Excel) is needed

    How to sort goods in stock by last sales periods by days:
    361 >
    181 - 360
    91 - 180
    61 - 90
    31 - 60
    1 - 30