Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Risk matrix chart in Power BI

Hi,   I am trying to create a risk matrix chart in Power BI like the one shown below. The elements in the matrix must have filter capabilities whereby clicking on an element should show all the pro...
Need Help
trutz's avatar
trutz
Icon for Advocate IV rankAdvocate IV
8 years ago

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

Ciria's avatar
Ciria
Icon for Advocate III rankAdvocate III
8 years ago

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,