Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |