Sort data matrix by column values

[mlane1]

Hi all,

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?

I appreciate any feedback.

Thanks,

Mike

[Phil_Seamark]

Hi @mlane1

Does it sort for you when you click on the column header?  

[mlane1]

It does not. It just spotlights the column.

[Phil_Seamark]

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]

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

[v-jiascu-msft]

Hi @mlane1,

I would suggest you vote up these ideas. 

power-bi-ideas/suggestions/9005872-matrix-sort-rows-by-value-asc-or-desc

265200-power-bi-ideas/suggestions/13808061-matrix-sort-columns-by-value

Best Regards,

Dale