Data for the 5 and 6 is not showing up on report view, even though it is there in data view for just the second column. The second and third column both come from the same file, and I don't have any dates filtered out. I was wondering how to fix this?
Could you share a sample pbix file which can reproduce this issue? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.