Thank you for the response, but the column headers and row headers are not constant when the risk data has not one of the likelihood level and impact level. I tried to fix it but I could not.
Hello 👋🏼, thanks for your comment. I will put it in my topics list. Meanwhile, I have created construction progress animated report before. Have a look: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Thanks for the video. I was wondering if you could write what you pasted at the 8:14 to get the colours for the matrix? What you pasted in is very small on screen. Thanks
nice stuff mate, thank u! i want to ask this, is it possible for us to make another slicer like categories and doesnt change the matrix? if it is, would you tell me how? thank uu
Hello 👋🏼, if you mean that you want to prevent the slicer from filtering the data shown in the matrix then you need to edit slicer interactions. Here is how you do it: learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop But if you want to filter the data without affecting the structure of the matrix then please follow this tutorial: Power BI Tutorial: Create An Advanced Risk Matrix Visual - P2 | NextGen BI Guru th-cam.com/video/SgxENdJc890/w-d-xo.html
In fact, I did the risk matrix, but I had a problem: the risk matrix should cover all levels of impact and likelihood (row headers and column headers); otherwise, the heat map does not contain all levels. I do not know what the problem is.
Hello 👋🏼. Please check out the following tutorial Power BI Tutorial: Create An Advanced Risk Matrix Visual - P2 | NextGen BI Guru th-cam.com/video/SgxENdJc890/w-d-xo.html. Also, from description you find a link to download the Power BI file
Hello 👋🏼, this is just a unique ID or index for each row I used it to count records. You can easily generate an index column from Power Query, there is an option to create an index column
Hey, nice Video, I have a problem with my "copy" of your matrix, it counts only the amount per row / Line which means for example in the Matrix 1-1 it show 18 Items, but in ROW 2-1 or 1-2 0 even if I have data within that field. Same for 2-2 3-3 and so on. could you help me?
Hi Hassan, I am not if I understood your question but it seems that you have problem with the data model. Did you download the dashboard? Are you using more than one table connected together?
Hello, Could you please provide me with guidance on a free or paid course that focuses on creating an interactive dashboard for construction risk management? I am looking for a professional-level course that can provide comprehensive instruction and guidance in this specific area. Thank you.
Hello 👋🏼, I am not aware of a course that is specific to this topic. However, there are many courses on creating interactive dashboards let me know if you need me to share some. Also, I will add it to my topics list and will try to cover it in the near future.
Great, but please create full construction project risk report using the power bi ❤🎉
Hello 👋🏼, thanks for your comment. I’ll put it in my topics list.
Thank you, this is very kind of you ❤️
Thank you for the response, but the column headers and row headers are not constant when the risk data has not one of the likelihood level and impact level. I tried to fix it but I could not.
Full risk dashboard will be amazing, please consider this request 🙏
Hello 👋🏼, thanks for your comment. I’ll put it in my topics list
Can't wait for the next video, please make construction project dashboard
Hello 👋🏼, thanks for your comment. I will put it in my topics list. Meanwhile, I have created construction progress animated report before. Have a look: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru
th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Thanks for the video. I was wondering if you could write what you pasted at the 8:14 to get the colours for the matrix? What you pasted in is very small on screen. Thanks
Hello 👋… thanks for your comment. You can download the PowerBI file it contains all the calculations. You find the link in the description.
Great stuff again, thanks!
Thank you 🙏
nice stuff mate, thank u! i want to ask this, is it possible for us to make another slicer like categories and doesnt change the matrix? if it is, would you tell me how? thank uu
Hello 👋🏼,
if you mean that you want to prevent the slicer from filtering the data shown in the matrix then you need to edit slicer interactions. Here is how you do it: learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop
But if you want to filter the data without affecting the structure of the matrix then please follow this tutorial: Power BI Tutorial: Create An Advanced Risk Matrix Visual - P2 | NextGen BI Guru
th-cam.com/video/SgxENdJc890/w-d-xo.html
I would like to know how to calculate the Ref column.
Hello 👋🏼, You can find a link in the description to download the Power BI file
In fact, I did the risk matrix, but I had a problem: the risk matrix should cover all levels of impact and likelihood (row headers and column headers); otherwise, the heat map does not contain all levels. I do not know what the problem is.
Hello 👋🏼. Please check out the following tutorial Power BI Tutorial: Create An Advanced Risk Matrix Visual - P2 | NextGen BI Guru
th-cam.com/video/SgxENdJc890/w-d-xo.html. Also, from description you find a link to download the Power BI file
what does your 'ref' column mean and what does it represent?
Hello 👋🏼, this is just a unique ID or index for each row I used it to count records. You can easily generate an index column from Power Query, there is an option to create an index column
@@NextGenBIGuru I don't understand the video after 2 minutes 40 seconds, I am unsure why the ref column is used and how its created using Power Query.
Hi hamzeh
Hello Saif
Hey, nice Video, I have a problem with my "copy" of your matrix, it counts only the amount per row / Line which means for example in the Matrix 1-1 it show 18 Items, but in ROW 2-1 or 1-2 0 even if I have data within that field. Same for 2-2 3-3 and so on. could you help me?
Hi Hassan, I am not if I understood your question but it seems that you have problem with the data model. Did you download the dashboard? Are you using more than one table connected together?
Hello,
Could you please provide me with guidance on a free or paid course that focuses on creating an interactive dashboard for construction risk management? I am looking for a professional-level course that can provide comprehensive instruction and guidance in this specific area. Thank you.
Hello 👋🏼, I am not aware of a course that is specific to this topic. However, there are many courses on creating interactive dashboards let me know if you need me to share some.
Also, I will add it to my topics list and will try to cover it in the near future.
Thank you for addressing the inclusion of construction risk management in your TH-cam channel. I eagerly anticipate your forthcoming videos.
You are welcome 🙏