Power BI User on 23 Dec 2015 22:09:02
If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity
Administrator on 18 Dec 2020 23:57:00
This has been implemented for tables as of March 2020:
Power BI Desktop March 2020 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
We're well aware, however, that more can be done to improve its discoverability--as well as to extend support for the feature to other visuals (like the matrix). Keep an eye out for future developments!
- Comments (248)
RE: Add a multiple columns sort feature
Please add this.
RE: Add a multiple columns sort feature
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.
RE: Add a multiple columns sort feature
Please add this feature. It would be really really helpful!!
RE: Add a multiple columns sort feature
Even Excel knows this functionality. :-) It would be a very nice to have when sorting on yearweeknumber.
RE: Add a multiple columns sort feature
Need this too!
RE: Add a multiple columns sort feature
Please, I need this
RE: Add a multiple columns sort feature
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.
RE: Add a multiple columns sort feature
Please add this.
RE: Add a multiple columns sort feature
Please add this feature ASAP. It's really needed.
RE: Add a multiple columns sort feature
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