Matrix Sort By Column

[udian]

Hi,

I am using power bi connected live connection to my tabular cube.

I am trying to sort my matrix using my dimension ID column but the "Sort by Column" option is greyed out. I guess this is because i am using live connection.

How can i sort my matrix?

Thanks!

[rjhartop]

If anyone is still looking for a solution, this blog post may be useful:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

You will likely need three slicers to sort by each of the different parent, child.. column headers

[v-sihou-msft · Accepted solution]

@udian

No. It's not possible to sort column groups within a matrix.

Since each entry supposes to be repeated along with row group, even you don't put any field on matrix, it still doesn't support sort on some field. 

Regards,