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

fortiz's avatar
fortiz
New Member
8 years ago

Hi,

 

How do you incorporate the color´s to the matrix?

  • trutz's avatar
    trutz
    Icon for Advocate IV rankAdvocate IV
    8 years ago

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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