Report is displaying blanks when using a calendar table

[wetherington]

Hi,

I am currently using a calendar table for my model and am experiencing null values for my report after configuring the calendar table. 

I have completed the following steps: 

1. Adding the calendar table to the model

2. Relationship between calendar table and entity table

3. Marking calendar table as the calendar table

Background context 

• Data connector I am using is the Common Data Service

Relationship

Calendar.Date -> Invoice.Date (1M) 

Report 

Visualization settings:

Axis = Calendar.FiscalYear

//My calendar table 

Legend = Null

Values = Sales

Thanks! 

[amitchandak · Accepted solution]

@wetherington , Seems like Invoice table Date has a timestamp

Check by changing the data type to datetime and having a format that can display time, if so create a new column

date only = Invoice[Date].date and join this with the calendar.

Also, check your calendar has all dates in the invoice table