Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column SORTING in Matrix Visual

Hi Everyone,   I am facing an issue with the sorting of columns in Power BI Matrix visual.   Problem Statement : Below is the test data set that we are using. We want to sort country column i.e....
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey Anonymous 

 

Power BI does not have functionality for sorting by rows in a power bi matrix. Your options are

 

1. To try the sort by function in the visual or Modeling tab: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

2. Sort By in the query editor: https://community.powerbi.com/t5/Desktop/Sorting-columns-in-Query-Editor/td-p/339238

3. Pivot your visual to switch the columns and rows so you can simply click the column C header to sort by that column.

4. Use the RANK (or RANKX) DAX functions to ranks your countries and sort that way: https://community.powerbi.com/t5/Desktop/Dynamic-ranking-by-sorted-column/td-p/501152

https://powerbi.tips/2017/07/ranking-values-with-measures/

 

If this helps please kudo.

If this solves your problem please accept it as a solution.