Forum Discussion
Controlling the column order in a Matrix table
In a Matrix Table, how do I get the columns to sort so that 2018 is on the left side of 2017. I have played around with column indexing with no luck. I think I was able to do it years ago but I have forgotten.
Hi Anonymous
As tested, It doesn't support to sort column header on descending order, it is sorted on ascending order by default.
As a workaround, i go to Edit queries, create a conditional column
Apply&&close
Select "Year", then select "sort by column"->custom
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-juanli-msftCommunity Support
Hi Anonymous
Zubair_Muhammad provided a good solution here, please check if it helps.
If not, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- v-juanli-msft
Hi Anonymous
As tested, It doesn't support to sort column header on descending order, it is sorted on ascending order by default.
As a workaround, i go to Edit queries, create a conditional column
Apply&&close
Select "Year", then select "sort by column"->custom
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.