How to Sort Vulnerabilities by a custom Risk Level in Power BI?

[mr_zz]

Hey everyone,

I'm working on a cybersecurity project where I need to sort vulnerabilities by their risk levels in Power BI. I've trying to make it work , but it doesn't order correctly. .

Objective: To sort a list of vulnerabilities by their risk levels (Critical, High, Medium, Low) in Power BI.

https://drive.google.com/file/d/13P2zldPhCKaFgGAdcWQxwJtaEc6LUsBB/view?usp=drive_link

[Rohit001 · Accepted solution]

Hii @mr_zz  Just click on vuln column and then sort by the priority 

[Rohit001]

Remove that summarization as a sum from the priority column 

[mr_zz]

how did you do it? I got "it's not possible"

[mostho]

You used a matrix visual with "firstr of risk" as values. Use a table visual and use "dont summarize" for risk.

[mr_zz]

I need to use a matrix instead of a table because I have to wrap each vulnerability name and URL as a single data if they are duplicated.