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.

[Evelyn_L]

Hi I think this solution is what I am looking for as well. But do you need to create a measure for every dates/months in your table?

[Shruthi96]

Hi @Evelyn_L 

Month Complete = IF(EOMONTH('Date1'[Date],0)<=TODAY(), "Yes", "No")

I applied above measure to the visual it worked. 

[Evelyn_L]

Thank you ! But I am referring to the second method he used in the video to sort the row by each column, he created two measures for offline and onlinesales added to the value. but my column is week/month, i was wondering if I will need to create measure for each week and month I have.