Forum Discussion
Risk matrix chart in Power BI
Hi,
I found a rather nice solution by using a scatter chart and aligning the "plot area" with an image that displays the matrix:
Risk Matrix
- Ciria8 years ago
Advocate III
Dears:
Following with what trutz has suggested, I have created a background image to set on "Plot" area,
In my case, I'm trying to build a Kraljic Matrix, very useful in purchasing.
Source:
https://www.forbes.com/sites/jwebb/2017/02/28/what-is-the-kraljic-matrix/#430105fe675f
Using Adobe Indesing (specially for aligning features this software has built in), I have created a cross adding some text right close to central dot.
The image I have created is larger than the visual itself, specially thinking in "Focus Mode". In my case, the visual is 960 pixels width, 350 height, and the picture created is 1280*1024 (screen resolution).
In any case, you can adjust the picture using "Image fit options" on "Plot Area" Section.
Here the picture:
Here how the scatter chart looks like:
Note: this is fully functional and interactive with other visualations.
Hope it helps.:smileyvery-happy:
Regards,
- fortiz8 years agoNew Member
Hi,
How do you incorporate the color´s to the matrix?
- fortiz8 years agoNew Member
Hi,
How do you incorporate the color´s to the matrix?
- trutz8 years ago
Advocate IV
I created an Excel sheet that had the same width/heigth ratio for the cells as the scatter plot area.
Then I coloured the cells and took a screenshot of that. I then added the picture as background picture to the plot area.Create color chart
- Anonymous8 years agoNot applicable
Thanks,I shall try this out. Is it possible to make it interactive? I want the slicers to filter the other visuals on the page