Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Issue with Displaying Full 10x10 Matrix

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 ...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

rsbin's avatar
rsbin
Community Champion
1 year ago

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,