Forum Discussion
Rnaval
1 year agoPost Partisan
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...
- 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 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
Rnaval
1 year agoPost Partisan
Tried Shift Key press on both columns but then Severity of Low appears before Medium. Is there a way to control via DAX?