Forum Discussion
How do sort a matrix visual?
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 null2. 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
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
One last question - is there a way to hide a column in the matrix visual?
