Forum Discussion

mr_zz's avatar
mr_zz
New Member
2 years ago
Solved

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

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

 

5 Replies

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

    • mr_zz's avatar
      mr_zz
      New Member

      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. 

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

     

    • mr_zz's avatar
      mr_zz
      New Member

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

       

       

    • Rohit001's avatar
      Rohit001
      Helper I

      Remove that summarization as a sum from the priority column