Forum Discussion

WeiweiCai's avatar
WeiweiCai
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Data 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

 

2 Replies

  • Assuming Import Mode. First thing you want to do is go to the data view and verify that the raw data (without filters) is actually there.

    • WeiweiCai's avatar
      WeiweiCai
      Icon for Microsoft Employee rankMicrosoft Employee

      Yes, verified in Data View (without filters), the records are existing there.