Skip to main content
Microsoft Idea

Power BI

Planned

Custom order for legend

Vote (4892) 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 (340)
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

Krishna Sankar's profile image Profile Picture

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

RE: Custom order for legend

yes please

Krishna Sankar's profile image Profile Picture

sami_gc on 16 Aug 2020 04:01:26

RE: Custom order for legend

This would be a great feature! please share us if you are implementing it

Cheers!

Krishna Sankar's profile image Profile Picture

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

RE: Custom order for legend

definitely please add, my stacked bar charts make no sense without this haha

Krishna Sankar's profile image Profile Picture

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

RE: Custom order for legend

PULEASE ADD AND STAT!

Krishna Sankar's profile image Profile Picture

Charles on 16 Aug 2020 04:00:54

RE: Custom order for legend

This would be handy. There are workarounds, like creating measures for each segment and adding them individually to the chart. But that is just plain ugly.

Krishna Sankar's profile image Profile Picture

Lars Johannes on 16 Aug 2020 04:00:51

RE: Custom order for legend

Should be a priority if Power BI really wants to be an option for dashboarding or any application people have to share with management or an audience outside of data crunchers.