How to sort the matrix column header values

Question

The data in the table is&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I am using weekend date as column values in the matrix table.&nbsp;&nbsp;The ouput is&nbsp;&nbsp;The matrix column header values in appropriate order. How to display the column header values in ascending order ?

greg_deckler · Answer

You will need a "Sort By" column. See attached, Table9, Page 8.
&nbsp;
Date is "Sorted by Column" the SortBy column. You access this by clicking on Date and then go to the Modeling tab.

v-qiuyu-msft · Answer

Hi&nbsp;Anonymous,
&nbsp;
You can go to Query Editor, sort the "weekend date" column in descending order, then add a index column from 1. Apply the change.&nbsp;
&nbsp;