Forum Discussion
Matrix column Sort (it is date column)
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
Idrissshatila , not sure how i missed the video in youtube. solution worked.. Thanks for sharing.
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?
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.