Forum Discussion
Need help swapping columns in Matrix Table
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
Hi gussiie,
It seems that you want to get the output like below.
If it is, please click the more option and select Sort Descending, check if this could achieve your requirement.
Best Regards,
Cherry
Hi
This does not work. It will only sort the rows or values. It does not sort the columns or give me an option to sort date by descending.
Are there any other ways?
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!