Forum Discussion
Solved
Matrix Visual - Sort by Day Of Week and Column Bucket
I'm using a Matrix visual to display events by Day of Week (rows) and time blocks (columns, e.g., 12a–5a, 6a–11a, etc.). I've created custom columns with corresponding sort columns (DayOfWeekNum, Tim...
Hi,
It would be important to see the table structure, but the sort column should be done only on your header column within the table. Create a column with the sort colum values like "SortColumn" below using a conditional column or table that can reference the sort values. Then go to "Column tools" and select the column1 header and then click on "Sort by column" and select "SortColumn"
I tried to recreate what you were getting, so I believe was able, so you do need to use the column from your "Audittimeblocktable" for the timeblocklabel rather then the one from the main table where your data resides in order it to work.
or you can create a new column in the main table to bring the "timeblocksort=
RELATED(AuditTimeBlockTable[TimeBlockSort])", then sort the "TimeblockLabel" in the main table by the new column.