I have two matrix tables that use the same dataset and are displaying the same values. The columns go by date, however one matrix has ignored about 20 out of 1000 records for one day/column. The rest of the matrix matches up with the first one. Why would it ignore a few rows in one matrix when all the data is being picked up in the other matrix?
According to my research and test, have you tried to turn on the “Show value with no data” option to check if the issue can disappear?
If you still have a problem, would you like to post a download link of the pbix file with this issue without the sensitive data if it’s pssible and we can help you to check if it’s an existing issue in the Power BI?