Forum Discussion
Matrix column Sort (it is date column)
Hi Folks,
I am exploring options to sort columns in a matrix visualization. However, I have observed that there is currently no option to sort columns; the sorting functionality is available only for rows. Please advise if there is a solution to address this limitation.
Thanks
Hello Shruthi96 ,
this is done in the table view, in the table having the date, on the column that you want to sort. when done there it will reflect on your matrix automatically.
check this out https://youtu.be/EVex9Gv-Hok?si=ZDK3NAggpJxGD_ND
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjGQsSdA47ewZE8uj?e=77rZUo
Sample PBIX file attached
9 Replies
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjGQsSdA47ewZE8uj?e=77rZUo
Sample PBIX file attached
Hello Shruthi96 ,
you need to sort this column in the data view with the feature sort by another column.
check it out https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop
Thanks for reply. I need for Matrix visualization. I dont get option to sort for column values for Matrix visualization.
Hello Shruthi96 ,
this is done in the table view, in the table having the date, on the column that you want to sort. when done there it will reflect on your matrix automatically.
check this out https://youtu.be/EVex9Gv-Hok?si=ZDK3NAggpJxGD_ND
