Matrix - Sort rows by value (asc or desc)
There is currently no customisation for sorting of matrices. Please copy existing Excel functionality to sort by row name or by value fields ascending or descending.
Sort out the Sorting soon! nearly 4 years since this idea was posted!
We need this.
Its is the basic in Excel that we use so much. Its so frustrating when I need to sort by total sold in 2018 for example, and I have more 3 columns like 2017, 2016 & 2015. It does not allow me to sort by last year, or by 2017 and so on. The sort option is either total columns or in alphabetical order by customer.
Adrian C commented
Please add in this feature!
Jeff Tennis commented
just discovered this today.....seriously? you cannot sort a matrix high/low by a column value?
CHIRANJIB MAZUMDAR commented
We need this, please.
Are you serious that I can't sort e.g. sales figures in ascending/descending order? This is the most basic feature of a table/matrix I can think of! It's comparable to not being able to send texts on my mobile... Please fix this asap!
Just piling on. A really necessary feature!
I get the sense that this feature is too hard for the Power BI MDX developers to figure out. I wish they would prove me wrong. :)
Will Power BI resolve this issue? Tableau still reigns supreme
Rhonda Smart commented
I need to sort by multi-year matrix with the current year to the left (descending) and my rows by category. Can I really not do this?
This is so fundamental, it's ridiculous. If you are displaying detail or showing values for different categories, you absolutely must be able to sort the rows and columns in a useful way. I am displaying pay grades by job titles, and the following sorting for columns is so ridiculous, it's embarrassing: 0 1 10 2 3 32 33 34 4 48 49 5 6...
Sorting matrixs table's row value by ascending or descending order is definitely needed.
Chad Thurston commented
A work around that I have found is to remove the columns the sort your values and add the columns back, however if you need it to interactive this will not be a solution for you.
Israel Fx commented
The same happens to me, if I can solve it ... :(
CALCULATE(SUM(sm_matrix[Negativo]), ALLEXCEPT(sm_matrix, sm_matrix[Semana Campaña]))
Erik BK commented
It is possible to sort by row name now.
But still not possible to sort by value if you have a field in "Columns". You cannot click on the columns to sort by value, it is only possible on the Total-column.
I also need control over the sort. When I bring an Excel file (with rows sorted the way I want them) into Power BI, it forces a different sort, which required me to begin the rows with "A.", "B.", "C.", etc. so that the rows were sorted in Power BI the same way they were in Excel.
TJ Doherty commented
If you just use values in a matrix, you can sort them. However, once you add column headers (e.g., grade values like 1, 2, 3, etc.) you lose the ability to sort the value columns. We need to be able to do that!
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).
In my opinion PBI should mimic Excel pivot tables as closely as possible.
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
Ralf Marpert commented
It is possible to sort by columns,
but there seems to be no existing way to sort by values :-(
VERY IMPORTANT TO ESTABLISH
It is very important to be able to sort words like week days, or months for instance. Many thanks !