Skip to main content

Power BI

New

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

Vote (102) 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 (5)
Ashish Singh's profile image Profile Picture

dd4a2578 1015-487f-945c-931c6201ebff on 06 Jul 2020 00:17:30

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

This would be extremely helpful

Ashish Singh's profile image Profile Picture

6633029c 1ed5-49ff-b5e7-b20add2046b6 on 06 Jul 2020 00:11:22

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

Would be extremely helpful, thanks!

Ashish Singh's profile image Profile Picture

fc20001c 8dbb-42e4-b771-6308c03e4093 on 06 Jul 2020 00:10:17

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

This is needed

Ashish Singh's profile image Profile Picture

8075f4b3 6963-41f0-aab3-184eff08f87c 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

04c2de65 8c90-4187-983d-5499cec4eec5 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).