Skip to main content
Microsoft Idea

Power BI

Needs Votes

Risk Matrix - Project reporting

Vote (100) Share
Zoe's profile image

Zoe on 08 Sep 2016 19:44:02

For reporting from Project 2013 a Risk Matrix would be a really useful visualisation. I have tried creating one using R but need to publish the report and add the matrix to the dashboard.

Comments (16)
Zoe's profile image Profile Picture

Trutz on 06 Jul 2020 00:12:44

RE: Risk Matrix - Project reporting

The standard scatter chart provides you with a good option. I outlined the approach here: https://community.powerbi.com/t5/Desktop/Risk-matrix-chart-in-Power-BI/m-p/275901/highlight/true#M123038

Zoe's profile image Profile Picture

Christian Papiccio on 06 Jul 2020 00:01:52

RE: Risk Matrix - Project reporting

We need a risk matrix

Zoe's profile image Profile Picture

Fernando on 05 Jul 2020 23:37:45

RE: Risk Matrix - Project reporting

Saludos, tengo una situación con una matriz que deseo implementar, espero puedan apoyarme.
La matriz en cuestión es una de Riesgo-Probabilidad, indica el riesgo y su probabilidad de ocurrencia, en la parte media contabiliza la cantidad de actiivdades que han tenido ese riesgo y esa probabilidad, anexo el link con el archivo pbix y Excel, el pbix contiene una imagen de como debería quedar al final.

https://ictamgroup-my.sharepoint.com/:f:/r/personal/fvelascor_ictamgroup-apt_mx/Documents/Doctos/Matriz?csf=1&e=lWbNDE

Agradecería cualquier ayuda o comentario que me puedan proporcionar. Gracias

Zoe's profile image Profile Picture

Fernando on 05 Jul 2020 23:37:45

RE: Risk Matrix - Project reporting

Esta sería la matriz resultante:
https://ictamgroup-my.sharepoint.com/:i:/g/personal/fvelascor_ictamgroup-apt_mx/EUXPsiv3cNJLq4-E2myed_QB9DcDZr9ote3QuF4rx86uYw?e=4lHdQf

Zoe's profile image Profile Picture

Manjula Gamage on 05 Jul 2020 23:24:26

RE: Risk Matrix - Project reporting

I have developed a Risk Matrix using PowerBI and Excel Plug-inns. It is working what we need.

Zoe's profile image Profile Picture

Manjula Gamage on 05 Jul 2020 23:24:26

RE: Risk Matrix - Project reporting

I can control my colours in each cell... any one interest I can share the techniques

Zoe's profile image Profile Picture

Raul Torvisco on 05 Jul 2020 23:14:01

RE: Risk Matrix - Project reporting

I strongly believe this could be a potential asset for Powerbi.

Another application of this Risk Matrix could be for designing Kraljic Matrix, really useful in Procurement/Purchasing.

Here a short brief:

https://www.forbes.com/sites/jwebb/2017/02/28/what-is-the-kraljic-matrix/#690d3799675f

Zoe's profile image Profile Picture

Bill Millen on 05 Jul 2020 23:02:28

RE: Risk Matrix - Project reporting

A risk matrix custom visual would be great, with consequence/likelihood scale and ability to set up colour and rating required (i.e. flexible). Big push for risk management and effective visuals for organisations. The suggested work around with matrix image (designed in Excel) in a scatter plot not ideal, and messy with labels, etc.

Zoe's profile image Profile Picture

Timothy Blackwell on 05 Jul 2020 23:00:50

RE: Risk Matrix - Project reporting

Really need a good risk matrix so we can replace Tableau!

Zoe's profile image Profile Picture

Power BI User on 05 Jul 2020 23:00:12

RE: Risk Matrix - Project reporting

I've set up a risk register in O365 SharePoint; would love to be able to publish the results in Power BI.