Skip to main content
Microsoft Idea

    Power BI

    Planned

    Custom order for legend

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

    Blake Smith on 16 Aug 2020 03:51:31

    RE: Custom order for legend

    It would very helpful if when working in the data modeling that we could rearrange the ordering of the Fields displayed in the right pane.

    Krishna Sankar's profile image Profile Picture

    Nitin Saluja on 16 Aug 2020 03:51:27

    RE: Custom order for legend

    Hi,
    Yes, I think this is good feature to have because let me give example, I have bar graph with Actual and Forecast values. Now If I want to show Forecast bar before Actual, so that we visualize how is company’s achievement against forecast. I am not able to change order of bar/legends.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:48:37

    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:48:31

    RE: Custom order for legend

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

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:48:24

    RE: Custom order for legend

    Yes please!

    Krishna Sankar's profile image Profile Picture

    Anne on 16 Aug 2020 03:48:23

    RE: Custom order for legend

    I would like the feature so that I can sort survey response categories (for example: Strongly Agree, Agree, Disagree, Strongly Disagree)

    Krishna Sankar's profile image Profile Picture

    Blake Smith on 16 Aug 2020 03:48:19

    RE: Custom order for legend

    It would very helpful if when working in the data modeling that we could rearrange the ordering of the Fields displayed in the right pane.

    Krishna Sankar's profile image Profile Picture

    Nitin Saluja on 16 Aug 2020 03:48:16

    RE: Custom order for legend

    Hi,
    Yes, I think this is good feature to have because let me give example, I have bar graph with Actual and Forecast values. Now If I want to show Forecast bar before Actual, so that we visualize how is company’s achievement against forecast. I am not able to change order of bar/legends.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:42:29

    RE: Custom order for legend

    Yes please!

    Krishna Sankar's profile image Profile Picture

    Anne on 16 Aug 2020 03:42:28

    RE: Custom order for legend

    I would like the feature so that I can sort survey response categories (for example: Strongly Agree, Agree, Disagree, Strongly Disagree)