Forum Discussion
HenryJS
Post Prodigy
Post ProdigyMatrix Sort Date Newest To Oldest
Hi all, Is it possible to sort week ending's in a matrix Newest to Oldest I have tried sorting Week Ending by Week number but it won't let me as there are multiple of the same week number acr...
amitchandak
Super User
Super UserHenryJS , Create columns like these
Week ending 1 = [week ending]
week ending rank = rankx(all(Table), [week ending] ,,desc,dense)
now mark week ending rank as sort column of Week ending 1 and use that in visual
sort column - https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column