Line values not showing on report

[Anonymous]

Hello All,

I have an issue where i cannot get the line values to show up on one Line and Stacked Colmn chart, but with all the same parameters (I think) it shows on the other.  The only difference is the raw data, but they're formatted the same.  

For context, what I'm trying to do is show how many returns we've had each month as the line value, and the stacked column value is the top 3 defects and what percentage they are of the total amount of returns.  

This one worked fine:

After selecting the same data except for Imports i get this:

Any help is greatly appreciated!

[mahoneypat]

Perhaps the measure used for the line is returning blank in the 2nd visual.  You can convert it to a table to check.

Pat

[Anonymous · Accepted solution]

I ended up having an invalid date format ( it was in the sheet as January 20211 so it errored out).  Just took some digging and I was able to figure it out.  Thank you for the help though!

[Anonymous]

To add on to the connundrum, for some reason, i cannot convert the date for this set of data to Date from Text.  All others picked up on this automatically.  I believe this is the issue, but i do not know how to resolve it.  Deleteing it doesn't do anything of a benefit as i get a static line of the sum of total pairs returned.  Shoudl I enter a new data table to aleviate this?