Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! 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.
Regards,
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
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |