Forum Discussion
Solved
Need matrix column sorted descending order
Hello, I'm trying to create the following pivot table in Power BI. I need help on how to sort the date table. The year and month column need to be in descending order( December 2022, November 20...
nrc0610 , for that you have create a column with desc sort
Month year 1 = [Month Year]
Month Year Sort = rankx(Date, [Month Year],,desc,dense)
Then mark Month Year Sort as sort column for Month Year 1 and use that in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
amitchandak
Super User
Super Usernrc0610 , for that you have create a column with desc sort
Month year 1 = [Month Year]
Month Year Sort = rankx(Date, [Month Year],,desc,dense)
Then mark Month Year Sort as sort column for Month Year 1 and use that in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Amit, thank you very much. Worked flawlessly.