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.
Daniel Adler commented
A kind request to embed the functionality of having a plain row number / index column that is not affected by sorting or anything in the visual, just goes from 1, 2, 3 and on
Perhaps scope creeping, but is dependent on column sorting and more or less impossible to create a dax for if there are several columns that can be sorted on i a table or matrix.
Would be great if it could be picked in the same go as it should only be a visual effect on the table and matrix.
Has to be done this complicated and crazy-work-aroundish way today:
Wait wait... Damm why Power BI Team Why.. ?
Good to see this is within the backlog!
Have up-voted to try and push through as quick as possible, very critical feature.
Halp this is such a PIA
It would be perfect for end-users analysis. Congrats by this idea.
Juan Manuel Lacy commented
This really needs to be completed soon.
Absolutely necessary, it is one of the basic feature for analytic tool to have
This is a simple sort that would solve a ton of formatting issues and calculations. Please add the sort option.
[Deleted User] commented
Very simple need
Looks like I get to join the crowd here asking why Microsoft why? This seems like such a basic and standard feature across many of your products but not in Powerbi? Being limited to one sort in a table is not cutting it, for me a Matrix is not going to work. As a work around I tried sorting my data in SQL first, it appears correctly in the query editor within Powerbi but then the table just ignores my order by reference. A few weeks ago my boss forwarded one our our Customers Tableau reports, I thought it was a logical choice to continue using a Microsoft products, based on the other software we use but I guess it is time to check out the competition.
Agree. Business needs this. We don't need to solve this on query level. It is on visual level for end users.
Ian Pinkett commented
QoL for end users is vital in moving towards report standardisation. It is impossible for me to ask people to move away from home brew excel solutions when basic functionality is lost. Admin please update on where things currently are with this. Tableau does not seem to have this issue.
Agreed - silly that this is available in Excel but not Power BI
when will you're going to be serious about user problem business want this feature, we need this badly, please get this ASAP we can't wait till next year MBAS for announcement than another few months for roll-out.
Jonathan Watters commented
to put it simply, this software should not be advertised as a complete solution if we can't even sort by multiple columns. mind boggling. this is hitting a 500 ft homerun and deliberately refusing to touch first base
Matthew Harris commented
I was enjoying a nice Shiraz by an open fire when my children ran into the drawing room screaming, they revealed that upon attempting to catalogue and analyse their insect collection they were unable to sort through multiple columns within power bi. Please add this feature, for the sake of the children. Please think of the kids!
It's really really necessary.
Mike G commented
Would like a Multi- Column / Advanced Sorting Option. Trying to look at freight expenses than by Sales Number of Sales Orders, but not allowing me to do what I want without the advanced sort option.
Please add multi level (or column) sort capability to power bi.