Forum Discussion

Rnaval's avatar
Rnaval
Post Partisan
1 year ago
Solved

How do sort a matrix visual?

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 c...
  • kushanNa's avatar
    1 year ago

    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