Created Date Table but in the chart, it does not show out

[CalvinIce]

Hi all, I want to request help on my dataset modeling issue.

This is the senario, I have pull the sales invoice data from my ERP (dynamics 365 FO), I wanted to build time intelligence related report so I have created a date table with a datetime type column for it as show below.

Here the issue comes, when I want to check sales amount trend over the time by the sales amount and the date with the stacked area chart, the chart show nothing as below showing. 

I am not sure what is happening, can anyone help me on this? Thanks.

[DataNinja777 · Accepted solution]

Hi @CalvinIce ,

Have you created the relationship between your calendar (date) table and your fact table (CustInvoiceJourBiEntities)?  

Also, have you set the data table as "Mark as a data table"?

If you you have done so, you will be able to create a chart like below:

I attach a pbix file for your reference.

Best regards,

[danextian]

-

[PhilipTreacy]

Thanks @danextian  I was already dealing with this, no need to jump in

[danextian]

sorry. i didnt notice. deleted my post.

[DataNinja777 · Accepted solution]

Hi @CalvinIce ,

Have you created the relationship between your calendar (date) table and your fact table (CustInvoiceJourBiEntities)?  

Also, have you set the data table as "Mark as a data table"?

If you you have done so, you will be able to create a chart like below:

I attach a pbix file for your reference.

Best regards,

[PhilipTreacy]

Hi @CalvinIce 

Have you marked your Date table as a date table?

Have you created a relationship from your data to the date table?

Hard to diagnose the issue without knowing what you have done - please provide your PBIX file.

Phil

[CalvinIce]

Hi Philip Treacy,

I have marked it as Date Table and also created a relationship. However, I am not sure part which is going wrong. 

I have attached my pbix file in this link.
https://limewire.com/d/894Nd#QAE1EoZyvL

[MasonMA]

So if 'CustInvoiceJourBiEntities[CreatedOn]' is Datetime data type you will need yo split the time from date in Power Query. Simply changing the date type in power bi won't make a difference. 

[PhilipTreacy · Accepted solution]

Hi @CalvinIce 

The date column in your Date Table is of type Date but the OrderedOn column contains Date Time data.  Both columns need to be the same data type so add a new date column to your data table.

See this file for working example 

regards

Phil

[MasonMA]

Hi,

If the relationship between your Date table and Fact table is active, one of the other possibilities would be your 'CustInvoiceJourBiEntities[CreatedOn]' is of Datetime data type. 

Mismatch in granularity causes blank visuals (for example 2025-10-10 14:23:45 ≠ 2025-10-10.) 

So ensure both are Date only if you’re building a time-series trend chart.