Skip to main content

Power BI

Planned

Custom order for legend

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

Shawn Alpay on 16 Aug 2020 04:04:55

RE: Custom order for legend

The stacked bar chart visual is borderline useless without repairing this.

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 04:04:44

RE: Custom order for legend

Very important if you warnt to avoid misinterpretations

Krishna Sankar's profile image Profile Picture

Javier Van Dam on 16 Aug 2020 04:04:34

RE: Custom order for legend

very important! please add

Krishna Sankar's profile image Profile Picture

Christopher Eby on 16 Aug 2020 04:03:51

RE: Custom order for legend

when legend positioning is 'left' or 'right', it's in inverse order to the stacked bars themselves!

Krishna Sankar's profile image Profile Picture

Nuno on 16 Aug 2020 04:03:07

RE: Custom order for legend

'+1 basic formatting request... it should be added across all visuals where this would apply

Krishna Sankar's profile image Profile Picture

Vincent Ziyu Ding on 16 Aug 2020 04:02:25

RE: Custom order for legend

It could be easier for create flexible chart

Krishna Sankar's profile image Profile Picture

Swapnil on 16 Aug 2020 04:02:07

RE: Custom order for legend

Currently "Sort By Column" Option is not enabled for PowerBI Service as Data Source. I can understand Modeling is disabled, but why custom sort.
There are times When I want to sort by a column which I don't Want in Report.

Krishna Sankar's profile image Profile Picture

Power BI Ideas Admin on 16 Aug 2020 04:02:02

RE: Custom order for legend

We should have the ability to sort the rows appearing in a table or matrix based on a column that is not being displayed (eg a SortOrder field). Currently possible in SSRS (by default it respects the data order).

This seems to work for charts but not for tables. For example i would like HR row data in the table to be displayed in order of Job Seniority, which is only indicated by a numerical field in the source data that i do not want to display. Currently the table defaults to alphabetical order and can only be corrected by including the SortOrder column.

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 04:02:01

RE: Custom order for legend

In Tableau you can drag the fields in a chart into a different sort order and Tableau remembers it as a new sort order when the field is used again. Is PowerBI getting this feature?

My department is evaluating whether we can switch from Tableau to PowerBI and we would need this feature.

Krishna Sankar's profile image Profile Picture

Arne on 16 Aug 2020 04:01:34

RE: Custom order for legend

Yes please this is much needed