Skip to main content

Power BI

Needs Votes

Ability to specify custom sort (or order) on the Groups created through UI

Vote (227) Share
Ashish Singh's profile image

Ashish Singh on 01 Nov 2016 09:15:42

The newly available groups cannot be custom sorted unless additional sort column for this group is added in the model which is not so good. While creating the custom groups, Arrow buttons to move groups Up Down should be available and this order should be used by default sorting unless the user wants to sort asc or desc by some measure.

Comments (22)
Ashish Singh's profile image Profile Picture

Kyle Brown on 05 Jul 2020 23:53:01

RE: Ability to specify custom sort (or order) on the Groups created through UI

I think it would be nice if Power BI had a way to keep track of columns that are purely derived from other columns so that you could sort by them when grouping.

My specific use case is converting semantic version strings like 3.6.11 to 003.006.011 so that it sorts correctly against 3.6.9 which becomes 003.006.009. Since this is a purely derived field it could be treated as grouped when the field it is derived from is grouped. This would allow it to be used for sorting

Ashish Singh's profile image Profile Picture

Chris12 on 05 Jul 2020 23:48:00

RE: Ability to specify custom sort (or order) on the Groups created through UI

Seconded!

This idea has at least 4 later duplicates (each of which now has a comment by me referring to this idea).