Add a multiple columns sort featue
If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity
This is in our backlog. Please vote to receive updates as we make progress.
Please this would make my life easier
Please add this.
In matrix visual: First sort by field 1 and then by field 2 etc - this is an essential requirement! E.g. First sort by Total, then by month. Thanks.
Please add this feature. It would be really really helpful!!
Luc van de Plas commented
Even Excel knows this functionality. :-) It would be a very nice to have when sorting on yearweeknumber.
Need this too!
Please, I need this
Keith D. commented
Adding to the chorus for inclusion of multi-column sorting (for either table visualizations or underlying queries). This is a very basic reporting task which is trivial to do in Excel or SQL. I am shocked to find out it is not possible in Power BI. My Fortune 500 organization is evaluating Power BI for possible use at an enterprise level, but this sort of deficiency precludes full-scale adoption.
Please add this.
Please add this feature ASAP. It's really needed.
This is called Advanced Sorting in most BI tools. It usually opens a pop-up window where you can select the first column you want to sort on on and the associated sorting order.
Then you can add other columns you want to sort on next.
It should also give you the possibility to move columns up and down to manage the order in which the sorting should be applied
Would be great, my example . . . .
Either using the stacked column chart or clustered I would like to sort the following
1.) showing by months
2.) Total (sum) of categories, 8 different categories
3.) X-axis concatenate labels turn off
Issue: As soon as I try sorting the Total( sum) category by (Asc) the x-axis concatenate turn off option breaks.
In excel it works, I would like to see this working in power bi desktop/services
Again, would be great.
This would be a big help. I wanted to sort by project name, and then by the task id, so the list is in chronological order for each project.
this would be great!
Power BI makes very difficult simple tasks, for example, sort customized columns, I cant reorder columns in natural year monthly. I searched many documentation but its not clear and, when finally I think Im found possible solutions, this trigger a new error message. I'm frustrated
Adam J commented
Agreed, this is especially frustrating with the Table visualization (which I think you are referring to), considering that the data sources, if written in SQL, cannot contain an ORDER BY clause.
The Power BI support team confirmed that this multi-level sort isn't available at this time in Power BI, but it is an essential need for reports that provide raw data output. SSRS has this out of the box, Power BI should as well.
It should work just like Excel, for column data in a table, (i.e. sort by Column B Asc, then Column C Desc, then Column A Asc, etc).
Jorge Diaz commented
We are working on our first Power BI project and we are very surprised this functionality is not available. Excel & Cognos have it...
Bram Wijns commented
Indeed something that is currently missing and can be considered as basic functionality.
There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).
Not my text but I agree fully:
I think that Microsoft must spend more time on these basic, fundamentals of reporting / dashboarding. I worry that too often they spend more time chasing cool, "glitzy" functionality, at the expense of the core functionality that other products have