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

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Add a multiple columns sort feature

If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity
Status: Completed
Comments
Pavan6
New Member
This feature is very much required
frederico_alme1
New Member
Would be really Nice. I need to sort by Company and Year
PointyStick
Regular Visitor
Need to order by store, date. Very much needed feature.
darren_donhardt
New Member
Yes please, do add. Looking at migrating functionality from COGNOS impromptu to Power BI Desktop and this is important
stewart_hunter1
New Member
Totally agree. The 'solution' of creating a calculated column and sorting by that (similar with joining using multiple columns) is not really good enough.
holly_jahangiri
New Member
There are many very BASIC features that are not supported by Power BI. This is one of them. I don't think we should even have to vote on something this simple and straightforward - it's a feature of Excel.
amin_hussani
New Member
I agree with other comment, at least excel features should be part of Power BI.
caantjes
Frequent Visitor
I have several reports created where it would be nice to sort on multiple columns. For example (1) number of orders decreasing year and month or (2) seqenced by weeks the number of tickets for each department in decreasing volume. Part of this want is that the multi column sort is very flexible in MS Excel
allen_delaney
New Member
Compound sorting seems like a very basic reporting feature. I would hope it would be added ASAP.
ajuza
New Member
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).