Excellent and easy to follow - very impressive stuff which I'm going to try out at my place of work as we use heatmaps on our reports but they are static. Thanks 🙂
Thanks. it is helpful. I've 2 soubts. 1. What if i select an row in table. Will slicer get filtered? 2. What if i add any category/discipline/station slicers at top and use the.. will it filter risk slicer?
Awesome tutorial. Thank you, @Jason Davidson ! I have now used this for my portfolio projects. One question: When we select a risk on the right hand table, the slicer gets rearranged to show just the risk value for that selected risk. Any way we can fix the slicer to not change position?
Yes, you can add a +0 to the end of the measure that count the number of risks. This way even if there are no risks in a certain square, it will return a 0 value.
I am having problems seeing the data I imported. I have the slicer and the risk matrix created. When I click a button no data displays from my source. Do you have any tips?
I am getting an extra grid when selecting the post mitigation column. So ideally it is a 5 by 5 matrix but an extra grid in the row is making it a 6 by 5 matrix. Any solution to this problem? Thanks!
Off the top of my head it could be a few things. 1.) You have a blank value for a risk ranking. 2.) Your have 26 unique values, instead of 25. In the values assigned to each work order. Hope that points you in the right direction.
Excellent and easy to follow - very impressive stuff which I'm going to try out at my place of work as we use heatmaps on our reports but they are static. Thanks 🙂
Thanks. it is helpful. I've 2 soubts.
1. What if i select an row in table. Will slicer get filtered?
2. What if i add any category/discipline/station slicers at top and use the.. will it filter risk slicer?
Awesome tutorial. Thank you, @Jason Davidson ! I have now used this for my portfolio projects. One question: When we select a risk on the right hand table, the slicer gets rearranged to show just the risk value for that selected risk. Any way we can fix the slicer to not change position?
Yes, you can add a +0 to the end of the measure that count the number of risks. This way even if there are no risks in a certain square, it will return a 0 value.
Great video, thank you!
Sir I am your fan!!
Thanks 😊 appreciate your kind words!
I am having problems seeing the data I imported. I have the slicer and the risk matrix created. When I click a button no data displays from my source. Do you have any tips?
I am getting an extra grid when selecting the post mitigation column. So ideally it is a 5 by 5 matrix but an extra grid in the row is making it a 6 by 5 matrix. Any solution to this problem? Thanks!
Off the top of my head it could be a few things. 1.) You have a blank value for a risk ranking. 2.) Your have 26 unique values, instead of 25. In the values assigned to each work order. Hope that points you in the right direction.