Forum Discussion
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 2022, October 2022, etc). Please see pivot chart image below:
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
2 Replies
- amitchandak
Super User
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-cAmit, thank you very much. Worked flawlessly.
