Custom sort column matrix table

Hi, Anonymous 

Based on your information, I create a sample table:

Then create a new table, give it a fixed sort:

Table 2 = 
SUMMARIZE('Table','Table'[Category],"_Sort",SWITCH(
         'Table'[Category], 
         "Overall DQ", 1, 
         "Accuracy", 2,
         "Completeness", 3,
         "Timeliness", 4,
         "Uniqueness", 5,
         "Validity", 6,
         99 
     ))

Create relationship, select the "Category" column, click "Sort by Column", and select the "_Sort" column

Add "Data Product Project Name" to the rows of the matrix, "Category" to the columns of the matrix in "Table 2", and "Score" to the values of the matrix, here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.