Power BI
Needs VotesAbility to specify custom sort (or order) on the Groups created through UI
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 (23)
RE: Ability to specify custom sort (or order) on the Groups created through UI
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).
RE: Ability to specify custom sort (or order) on the Groups created through UI
still not available in 2024, getting quite ridiculous
RE: Ability to specify custom sort (or order) on the Groups created through UI
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.
RE: Ability to specify custom sort (or order) on the Groups created through UI
Ridiculous that key features such as this is absent in the product.
RE: Ability to specify custom sort (or order) on the Groups created through UI
How is this still an issue can this be addressed
RE: Ability to specify custom sort (or order) on the Groups created through UI
Sorting legends is such a hassle in Power BI. Every graph needs some custom table and a massive unintuitive rigmarole just to get it looking like Excel. And I used to think Excel graphs were awful.
RE: Ability to specify custom sort (or order) on the Groups created through UI
I am new to PowerBI and was amazed and really disappointed to find out that using your own sort order in an easy way (without using extra sorting table or giving numbers to the variables) is not possible. Tableau and QlikSense handle this perfectly, come on Microsoft!
RE: Ability to specify custom sort (or order) on the Groups created through UI
The little things make a professional product
RE: Ability to specify custom sort (or order) on the Groups created through UI
Please add this Microsoft. So far I am very disappointed with Power BI. There seems to be a lot of very obvious things missing.
RE: Ability to specify custom sort (or order) on the Groups created through UI
This is a no brainer. To have to make your own sorting by putting number in front of the text to sort it in the order that you want is tedious and the outcome of the text is not good.