Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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

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.
Status: Needs Votes
Comments
fbcideas_migusr
New Member

Just ran in to this issue now. One of about 30 issues I would've expected would have a normal, easy solution, but it requires you to obfuscate your data tables by adding additional columns, helper tables, custom DAX, etc etc, all to produce the same result you can get in Excel. Ridiculous.

Jasmine_Ho
New Member

still not available in 2024, getting quite ridiculous

Samuel_Fletche1
New Member

Truly baffling that this wasn't implemented immediately as part of the grouping capability, no less that it still hasn't been so many years later... it's one of the single most basic, foundational features that any user would need when adding custom groups. The workaround of creating a separate mapping table and adding a calculated field value for every single record in the dataset is one of the most egregious examples of adding unnecessary complexity and creating redundant data for such a basic and simple exercise that I've ever encountered. Excel pivot tables have been able to do this for at least a decade, if not longer (not to mention in a much more convenient way by clicking & dragging fields right on the table/visual itself, another area on the list of features in which PowerBI is many years behind Excel in... but I suppose that's beside the point for this particular issue).

fbcideas_migusr
New Member
Status changed to: Needs Votes