sort report by Matrix columns

Question

Hi,&nbsp;I have a table, something like this&nbsp;Application_Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;source&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;User_IDExcel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123Excel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;124Excel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Desktop&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 125Excel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;126Excel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;127Excel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;128Word&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123Word&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Desktop&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;124&nbsp;I have created a report using Matrix, Set Application_name as rows, source as columns and count of (user_id) as values&nbsp;Report looks something like this&nbsp;&nbsp;App&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Desktop&nbsp; &nbsp; &nbsp;TotalExcel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6Word&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp;I can sort this report by either Total user count or Applications.&nbsp;&nbsp;What I want is to sort this report by either Browser or Desktop user count (Brows&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

rjhartop · Accepted Answer

Hi,&nbsp;&nbsp;This blog post shows a work around:&nbsp;https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

Forum Discussion

sort report by Matrix columns

2 Replies

Related content

Matrix Column Widths

Matrix column based on other matrix columns

Matrix column not grouped

Power BI Matrix report

Matrix Report Ranking