cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Verity96

Matrix is not picking up a few rows of data.

Submitted by on ‎01-16-2022 02:27 PM

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?

Status: Investigating

Hi,

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?

vrobertqmsft_0-1642385813363.png

 

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?

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
1 Comment (1 New)
Comments
v-robertq-msft
Community Support
Community Support
‎01-16-2022 06:23 PM
Status changed to: Investigating

Hi,

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?

vrobertqmsft_0-1642385813363.png

 

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?

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses