Skip to main content

Power BI

Planned

Custom order for legend

Vote (5171) 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:51:34

RE: Custom order for legend

Yes please!

Krishna Sankar's profile image Profile Picture

Anne 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

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.