Forum Discussion
Solved
Need help swapping columns in Matrix Table
Hi Can someone please tell me how I swap 2017 and 2018 in the date column in a matrix table? Currently 2017 is showing first. I want 2018 to show first, followed by 2017. Please see img...
Hi gussiie,
Normally, matrix column header is not supported for sort by in power bi currently.
You could try this workaround below and have a reference of this blog.
1. Create a table with date and index
2. Create the relationship between the tables and create the calculated column year.
3. Sort calcualted column year by Index.
4. Create the matrix with calculated column year and Date hierarchy Quarter as column.
More details, you could refer to this attachment.
Best Regards,
Cherry
Thank you so much!
I love this community!