Skip to main content
Microsoft Idea

    Power BI

    Planned

    Custom order for legend

    Vote (4954) 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 (342)
    Krishna Sankar's profile image Profile Picture

    sosi on 16 Aug 2020 03:54:45

    RE: Custom order for legend

    i found something, there are 3 dots in the top right corner of the chart, here you can change the order of the bars.

    Krishna Sankar's profile image Profile Picture

    Fred Lorrain on 16 Aug 2020 03:54:38

    RE: Custom order for legend

    idealy the default sorting should be

    1. Folder (alpha sorted)
    2. Fields and calculated column (alpha sorted)
    3. Measures (alpha sorted)

    Krishna Sankar's profile image Profile Picture

    Jonathan Mukundu on 16 Aug 2020 03:54:13

    RE: Custom order for legend

    This should actually been in the first version of Power Bi. It will really making sorting much easier

    Krishna Sankar's profile image Profile Picture

    natan on 16 Aug 2020 03:53:59

    RE: Custom order for legend

    for example if i have this values in a column:
    0-5,5-10,10-15,15+
    and i wanted to display this value in a visual in this order.

    Krishna Sankar's profile image Profile Picture

    natan on 16 Aug 2020 03:53:56

    RE: Custom order for legend

    custom sort of strings
    for example i have this ranges:
    0-5,5-10,10-15,15+
    and i want to display the visual in this order.

    Krishna Sankar's profile image Profile Picture

    Jade Doherty on 16 Aug 2020 03:53:52

    RE: Custom order for legend

    '@N1c0l3 - thanks your workaround solution did the trick - but yes agree this should be a standard feature to allow custom sorting

    Krishna Sankar's profile image Profile Picture

    Thiago Zaiden on 16 Aug 2020 03:53:51

    RE: Custom order for legend

    This would be great for all charts!

    Krishna Sankar's profile image Profile Picture

    Liz on 16 Aug 2020 03:53:49

    RE: Custom order for legend

    Does anyone have a quick workaround for this? Custom sort is a feature that is absolutely needed.

    Krishna Sankar's profile image Profile Picture

    N1c0l3 on 16 Aug 2020 03:53:49

    RE: Custom order for legend

    Quick workaround: since it's sorted alphabetically, rename the data to have some number of spaces before it. "__legend1" "_legend2" "legend3" will sort as desired. Legend displayed at top of page strips preceding spaces, but the desired sort is achieved!

    Krishna Sankar's profile image Profile Picture

    DCS on 16 Aug 2020 03:53:48

    RE: Custom order for legend

    I tried to solve this issue by creating a table with Legend elements in a column and another column, and then ordering elements in Legend by other column, but I defined that column in terms of the Legend column (CALCULATE, ALLEXCEPT AND SUM), so Power BI refused to change the Sort (thus avoiding some sort of loop). Having this feature would definitely make it easier.