Forum Discussion
Line values not showing on report
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!
3 Replies
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?
- mahoneypat
Microsoft Employee
Perhaps the measure used for the line is returning blank in the 2nd visual. You can convert it to a table to check.
Pat
