Forum Discussion
Advocate IPower BI Matrix Not Showing Values for All Category-Group Combinations
Thank you v-pnaroju-msft and Royel
I was able to resolve the issue but switching my dimension tables to dual mode(import mode works too).
A possible explaination I found for this is that, in DirectQuery Many to Many relationships generate complex subqueries for power BI and since my fact table right now have Many to many relations with my dimension tables, I have this issue. I am still looking into a detailed understanding of the behaviour.
Community SupportThankyou, Royel, for your response.
Hi nigama,
We appreciate your inquiry submitted to the Microsoft Fabric Community Forum.
Based on my understanding, the issue arises from the way rows and columns are defined and how the measure handles blank values. Implementing proper dimension tables and relationships ensures that every row and column combination exists, and using COALESCE ensures a zero is displayed where no assignment exists. With this configuration, the matrix correctly displays all categories and groups with their counts, shows zeros where no data exists, and preserves accurate totals.
Please find attached a screenshot and a sample PBIX file that may assist in resolving the issue:
We hope the information provided helps resolve your concern. If you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.