Forum Discussion
Solved
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 onl...
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
Hi Evelyn_L
Month Complete = IF(EOMONTH('Date1'[Date],0)<=TODAY(), "Yes", "No")
I applied above measure to the visual it worked.
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.