Forum Discussion

wetherington's avatar
wetherington
Frequent Visitor
6 years ago
Solved

Report is displaying blanks when using a calendar table

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! 

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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