Skip to main content

Power BI

New

Risk Matrix - Project reporting

Vote (84) 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

ad675ab8 4545-4def-90b2-0ee2659f745a 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

37b758eb 5f80-4555-8017-1c2c6cba7ff3 on 06 Jul 2020 00:01:52

RE: Risk Matrix - Project reporting

We need a risk matrix

Zoe's profile image Profile Picture

381a743f 35f1-4365-9636-d91db369ac43 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

381a743f 35f1-4365-9636-d91db369ac43 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

a0b7a3cc 0c5f-4853-8108-7878e7417677 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

a0b7a3cc 0c5f-4853-8108-7878e7417677 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

d9ae4ecd e25d-44c9-a187-5da24d57d20c 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

37b4ffed 62cc-4e0d-a574-db7fd596e4fc 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

3fe3305b e258-4f4b-873e-bd67315c8b87 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

7f6f3127 ac6d-4aab-b9c2-7e241a3ac723 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.