Skip to main content

    Power BI

    Planned

    Custom order for legend

    Vote (5175) 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

    Power BI User on 16 Aug 2020 03:52:36

    RE: Custom order for legend

    Yes, please. Ordered alphabetically sometimes does not make much sense. It'll be appreciated if the order of the column/row label of table or matrix could be customised as well, just like Excel does.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:22

    RE: Custom order for legend

    Definitely needed!

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:22

    RE: Custom order for legend

    Yea, for all charts please!

    Krishna Sankar's profile image Profile Picture

    Vito on 16 Aug 2020 03:52:08

    RE: Custom order for legend

    Can we get a similar function to Custom Sort Order just like Excel does it. This will fix quite a bit of the sorting issues we currently see in Power BI today.
    For Example:
    By Day of Week - Sunday to Saturday, Sun to Sat, etc
    By Month of Year - January to December, Jan to Dec.

    Give them a dialog or other options to control the order manually.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:05

    RE: Custom order for legend

    Essential when using buckets! Hopefully coming soon :)

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:05

    RE: Custom order for legend

    for all chart please!

    Krishna Sankar's profile image Profile Picture

    lenzy petty on 16 Aug 2020 03:52:05

    RE: Custom order for legend

    This is another example of a Power BI shortcoming that keeps sending me back to Tableau.

    Krishna Sankar's profile image Profile Picture

    Andy Youngblood on 16 Aug 2020 03:51:52

    RE: Custom order for legend

    This feature would be handy when reporting in terms of months, especially month-to-date reporting. Currently, I added an additional column and gave each month a numerical value (Jan-1, Feb-2, etc), and then hid the numerical column once sorted. This step is unnecessary and inefficient. Another option would be to include the numerical value in the name of the month ("1-January", "2-February", etc.). This option is redundant and aesthetically unpleasing. Just a thought!

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:51:45

    RE: Custom order for legend

    One work-around is to name the items in the legend with an appropriate number of blank spaces, so that when Power BI alphabetizes them, the leading spaces determine the order. So your categories could be:
    " Strongly Agree"
    " Agree"
    " Disagree"
    "Strongly Disagree"

    Krishna Sankar's profile image Profile Picture

    E on 16 Aug 2020 03:51:39

    RE: Custom order for legend

    So much of this. As Anne said, sometimes we don't want it in alphabetical order...