How do sort a matrix visual?

[Rnaval]

How do I sort a matrix visual using two separate columns, see below. I'm looking to sort by Severity column first in the following order (Critical, High, Medium and Low) and then by the Total Count coulmn in descending order.

[kushanNa · Accepted solution]

Hi 

do you have all these data in power query side ? then this should be less trouble

follow the following steps 

1. first create a severity order custom column 

= if [Severity] = "Critical" then 1 
    else if [Severity] = "High" then 2 
    else if [Severity] = "Medium" then 3 
    else if [Severity] = "Low" then 4 
    else null

2. sort it by new created column

3. sort it by total count 

4. create an index column 

5.apply changes

6. click on vulnerability title and sort it by index

7. sort it again by ASC if it do not get sorted properly 

[Rnaval]

One last question - is there a way to hide a column in the matrix visual?

[Rnaval]

Tried Shift Key press on both columns but then Severity of Low appears before Medium. Is there a way to control via DAX?

[sevenhills]

Did you try, by <SHIFT> key pressed and select multiple columns of your desire ?

Or you are looking for DAX to control it ?