Issue with Displaying Full 10x10 Matrix

[Anonymous]

Hello,

I hope you're all doing well.

I'm trying to create a 10x10 matrix using the following values:

• The "Likelihood" column is my Y-axis.
• The "Consequence" column is my X-axis.

I'm using the following dataset:

When I generate the matrix, it only displays the values that are present in my dataset, instead of showing the full range from 1 to 10 on both axes:

I need the matrix to display all numbers from 1 to 10, even if some values are missing.

How can I ensure that the entire 10x10 structure is displayed correctly?

Thanks in advance for your help!

[Anonymous · Accepted solution]

Hello,Bibiano_Geraldo and rsbin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@Anonymous .I am glad to help you.
I'll just summarize what others have suggested, and if you find it helpful, you can mark the suggestions made by Bibiano_Geraldo and rsbin as  the solutions .
1.You need to create two dimension tables representing the row and column fields of the matrix respectively, and both dimensions have complete data (data from 1 to 10)

Create one-to-many relationships(single)

Set the rows and columns "Show items with no data "
Show items with no data in Power BI - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[Anonymous]

Hello,

Your solution worked perfectly. Thank you so much for your help!

Best Regards,

Jesus G.

[Bibiano_Geraldo]

Hi @Anonymous ,

To see all values, you should show items with row data by right click in column placed in row fields:

[rsbin]

@Anonymous ,

You can create 2 separate Dimension Tables, one each for Likelyhood and Consequence.

These would be one-column tables with the values 1 - 10.

Join each table to your "Fact" table shown above. 

Then use these dimension tables as your Column and Rows in your Matrix.

Once you drag these into the field wells, make sure to select Show Items with No Data

Hope this helps.

Regards,