Sort a visual matrix that uses the "show as rows"

[alex_bi]

I will describe the challenge from the start, since it might be easier to get another way to reach to the solution.

So I have a table with many columns. A number of these columns are  responses to a questionaire and hold the exact same variables, let's call them Var1,Var2,Var3,Var4.... Imagine the variables to be Yes, No, Maybe etc.

What I want to do is create a visual matrix where the rows are the questions, and the column is the count of "No". I must be able to sort the matrix so only the first N questiions (the ones with the highest counts of Nos) are shown.

I created a measure for each var (using COUNTAX  that counts the number of nos, and then used the "show as rows" option to create a visual matrix. However while the result is a visual matrix in the way I want, I cannot sort it/ filter only the top N. 

Any proposed solutions to this?

[v-frfei-msft]

Hi @alex_bi,

Kindly share your sample data and excepted result to me.

Regards,

Frank

[alex_bi]

I will describe the challenge from the start, since it might be easier to get another way to reach to the solution.

So I have a table with many columns. A number of these columns are  responses to a questionaire and hold the exact same variables, let's call them Var1,Var2,Var3,Var4.... Imagine the variables to be Yes, No, Maybe etc.

What I want to do is create a visual matrix where the rows are the questions, and the column is the count of "No". I must be able to sort the matrix so only the first N questiions (the ones with the highest counts of Nos) are shown.

I created a measure for each var (using COUNTAX  that counts the number of nos, and then used the "show as rows" option to create a visual matrix. However while the result is a visual matrix in the way I want, I cannot sort it/ filter only the top N. 

Any proposed solutions to this?