Forum Discussion
WeiweiCai
Microsoft Employee
4 years agoData missing on Line and stacked column chart
We have a report that use Line and stacked column chart to display the data from our database. The datasource is from SQL Server Database.
The abscissa of Line and stacked column chart only display the data to 'date1'. But actually, there is an 'date2' behind 'date1'. And the 'date2' shouled have value '2'.
What I have done:
1. Checked the Data of this Line and stacked column chart, and confirmed the 'date2' records are exist in Data.
2. Checked the Query of Data, there is no filters filtered the records of 'date2'. According to the Query result, the records for 'date2' are exists in the preview table.
Ask for help:
Am I missing something here? Do you have any other suggestion to help me troubleshoot this issue?
Thanks