Matrix - Sort columns by value

[aotto]

Matrix currently doesn't allow you to sort the columns based on designating values as being a priority above the column field names. For example, my field in the columns section results in three columns. If you add two sets of values, you are forced to see: Column 1, Value 1, Value 2, Column 2, Value 1, Value 2, etc. Like in a Pivot Table, you should be able to prioritize values so that it shows as: Column 1, Column 2, Column 3, Value 1, Column 1, Column 2, Column 3, Value 2.

[kbr_sanka]

Any update on this feature? Hope you will add it soon 🙂

[diana661]

Please add this function

[vinay_tvkr]

I am looking for this feature on Matrix visual to sort the values based on the columns. Example if any table column values are having Top 50 and Last 50, when these are kept on the Matrix visual columns, Top 50 and Last 50 columns are created those we can't sort with those fields in Matrix visual.

[lynch_ce]

This is a highly needed ability, i'm amazed it doesn't exist in this visualization.

[m_merkt]

Please add this functionality! It is very much needed.

[saurabhdasgupta]

The ability to click on a column header of a Matrix and sort the results is a feature that would significantly improve the data visualization capabilities for our end users. Without the ability to click and sort, I find that users are spending a lot of time scrolling up and down. E.g. To find the lowest value or highest value. This is very unproductive. Thank you.

[stacy_swisher]

The lack of basic features like the inability to not sort a matrix with column headers provides ample arguments from business partners to not utilize power bi.

[sperkins]

To add to this, I have a matrix that displays calendar years as columns and would like the ability to sort these years from descending or ascending for example (Can currently be done in Excel Power Pivot but not Power BI) Department 2017 2018 2019 2020 2021 Sales Value Value Value Value Value Accounting Value Value Value Value Value OR Department 2021 2020 2019 2018 2017 Sales Value Value Value Value Value Accounting Value Value Value Value Value

[Jeff_Masse]

While not a direct solution, there is a simple workaround to this problem, it requires just two steps: 1. Create a new column in your table called "Sort Order". This columns needs to map 1:1 to the original column. This Sort By column should be in ascending order in the order you want your original column to be ordered. 2. Use Power BI's "Sort by" feature to sort your original column by the new "Sort Order" column you just created. For example, if you had Year in the columns of a matrix. You could get them in descending order by creating a new column Sort Order = -Year. Then use the Sort By feature in Power BI to sort Year by your new Sort Order column.

[David_Martinez2]

Perhaps I am missing the point, but doesnt the menu on the top right of the visual allow for a Sort By on any of the Values columns?