I’ve created a matrix in Power BI with two rows: Category and Sub-Category. I want to sort the matrix first by Category and then by Sub-Category. I have a separate table linked to my data table that contains both Category and Order columns for sorting Category, and another table with Sub-Category and Order columns for sorting Sub-Category. How can I sort the matrix first by Category (using the order from the linked table) and then by Sub-Category (using its own order from the second table)?
I can only sort by either Category or Sub-Category at a time in the matrix. How can I achieve sorting first by Category and then by Sub-Category using the linked order columns from both tables?
