Forum Discussion
Matrix Visual - Not Displaying Zeros
Hello L4TET ,
I pulled together a rough dataset to hopefully try and recreate your data and the problem. You can consider the following DAX for your Offense count per quarter:Offense Count = COALESCE(COUNT('Table (2)'[SubOffense]),0)This is how my result Matrix looks like:
My initial data looks something like this:
Hopefully this helps!
I apolgize for the delayed response, as I am a new user on the forums, there is a delay in my ability to post. I still am unable to resolve this issue. Based on your response, I feel as if I have contributed/caused this issue inadventerly. So my Fiscal Year & Quarter are stored as text from the original excel document (its how the system exports it) so they are in formats as 22 Q1, 22 Q2, etc etc. However I do have specific dates. After using some AI, I have toyed with creating a date table with custom quarters, and even with the custom quarters, I still have blanks instead of zeros. I feel like this is something really simple that I am completely overlooking. Thank you for everything so far and I look forward for your response!
Hi L4TET,
In Power BI, Matrix visuals only show combinations that exist in the data. So if an Offense/SubOffense didn’t occur in a specific Fiscal Quarter, that combination is missing — resulting in a blank, not a zero. A zero means the data exists but the value is 0, while a blank means the data doesn't exist at all.
Regards,
Vinay Pabbu