Forum Discussion
Issue with Displaying Full 10x10 Matrix
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 LearnI hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
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
Hello,
Your solution worked perfectly. Thank you so much for your help!
Best Regards,
Jesus G.