Sort data matrix by column values

Question

&nbsp;Hi all,&nbsp;I need to be able to sort this data matrix by the values in column 201806. For example in this case, Cardiology would be listed third highest. How can I do this?&nbsp;I appreciate any feedback.&nbsp;Thanks,&nbsp;Mike

phil_seamark · Answer

Hi&nbsp;mlane1&nbsp;Does it sort for you when you click on the column header?&nbsp;&nbsp;

mlane1 · Answer

It does not. It just spotlights the column.

phil_seamark · Answer

Oh ok, and do you get any sorting options in the context menu that pops up when you click the three small dots in the very top right-hand corner of the visual?

mlane1 · Answer

Yes, it allows me to sort by the&nbsp;data field name, thus total&nbsp;counts for that service line. Which shows in the picture. However I don't want it to sort by the total,&nbsp;I want it to sort largest to smallest&nbsp;by 201806 column values.

v-jiascu-msft · Answer

Hi&nbsp;mlane1,
&nbsp;
I would suggest you vote up these ideas.&nbsp;
power-bi-ideas/suggestions/9005872-matrix-sort-rows-by-value-asc-or-desc
265200-power-bi-ideas/suggestions/13808061-matrix-sort-columns-by-value
&nbsp;
Best Regards,
Dale

Forum Discussion

Sort data matrix by column values

5 Replies

Related content

Matrix Column Widths

Sort Matrix Columns by Values

Sort Column in based on the Row total values in Matrix visual

Matrix column based on other matrix columns

Splitting Column values