Skip to main content

    Power BI

    Needs Votes

    Custom order for legend

    Vote (2690) 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 20 Aug 2020 01:24:03

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

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

    b7f6a85d b076-4ead-91e0-490b514904eb on 16 Aug 2020 03:52:05

    RE: Custom order for legend

    for all chart please!

    Krishna Sankar's profile image Profile Picture

    61dd0c4c 00b9-4934-84a2-74a11b01fb87 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

    5e285e2d d70d-4a28-91fa-90b3d2c892dc 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

    6492468e c225-490b-952b-f02cd5ce1818 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

    5b36f1dc 56b8-4e7f-95b6-636ab77c42d9 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...

    Krishna Sankar's profile image Profile Picture

    288ed614 6787-48b7-be02-69ed861a4dd3 on 16 Aug 2020 03:51:34

    RE: Custom order for legend

    Yes please!

    Krishna Sankar's profile image Profile Picture

    38dbfac1 511e-4698-b56b-170c489810a5 on 16 Aug 2020 03:51:33

    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

    56a84ef9 85bf-444f-85cf-9f34f057b965 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

    b581ea8a ad4c-4faf-8926-701f185852e3 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

    6492468e c225-490b-952b-f02cd5ce1818 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"