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?
Go to Solution.
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.
View solution in original post
If anyone is still looking for a solution, this blog post may be useful:
You will likely need three slicers to sort by each of the different parent, child.. column headers
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.