Matrix column Sort (it is date column)

[Shruthi96]

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

[Idrissshatila · Accepted solution]

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

[Ahmedx · Accepted solution]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjGQsSdA47ewZE8uj?e=77rZUo

Sample PBIX file attached

[Shruthi96]

Attached PBI really helped.. Thank you so much @Ahmedx 

[Idrissshatila]

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-deskto...

[Shruthi96]

Thanks for reply. I need for Matrix visualization.  I dont get option to sort for column values for Matrix visualization. 

[Idrissshatila · Accepted solution]

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

[Shruthi96]

@Idrissshatila , not sure how i missed the video in youtube. solution worked.. Thanks for sharing.