cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
udian
Helper III
Helper III

Matrix Sort By Column

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?

 

Capture2.JPG

 

Thanks!

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft
Microsoft

@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,

View solution in original post

2 REPLIES 2
rjhartop
Helper II
Helper II

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
Microsoft
Microsoft

@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,

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors