Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
How can one change the sort order of a Pivoted column like this in a Matrix?
I can change the sort order of the column in Column Tools etc, but it doesn't update the order in the visual.
To pivot my Matrix around the [Year - WeekNumber] column , I have used the Switch Values to Rows option
Hi Amit
I can't follow your instructions. I currently have a column in the table like this. It's of type Text.
@andyor , Create columns like
Year Week 1 = [Year Week]
Year week sort = Rankx(Date, [Year week],,desc,dense)
Then mark Year week sort as a sort column of year week1 in column tools and use year week 1 in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |