Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have creating a date table with calenderauto. And now, I was made a matrix, with rows months and colums for years. But I want to sort the years descending, by default they are sorting by ascending. Can anyone tell my how to sort the years descending. Thank you!
Solved! Go to Solution.
@Moniek , For Matrix I doubt still option is not added. Option not added bar/stacked legends in Nov 2021.
You need to create these columns in table/date table
Year 1 = [Year])
Year Order = rankx('Date', [Year],,desc,dense)
Mark Year sort as sort column of the year and use that
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
@Moniek , For Matrix I doubt still option is not added. Option not added bar/stacked legends in Nov 2021.
You need to create these columns in table/date table
Year 1 = [Year])
Year Order = rankx('Date', [Year],,desc,dense)
Mark Year sort as sort column of the year and use that
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Thanks, your youtube helps me a lot!!!!!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |