Date as X axis help

[carlosflores]

Hello Community. I'm having some troubles with my date in the X axis.

I have a table looking like this:

I'm trying to count the amount of workers filtered by date, like this:

But as youcan see, there is plenty of data that appears as a Blank date. I have created a Date table and have linked it to my data table, like this. The link appears as dotted, don't really know why.

I would really appreciate help on this matter. I've been struggling with for a couple of hours. If there's a way I can send the file so you can see it, I would be happy to send it to you. I have checked the format of the date column and it is a formated as a date column. I don't really know what else I can do

Thanks in advance.

[Anonymous · Accepted solution]

The dotted line means that the link between the table is not presently active.  If you double click on that line you will get the link properties.  There is a tick box called "Make this relationship active".

If you are getting blanks in your table, this usually means that certain dates are not being related in to your date axis (usually your date table). Common reasons for this are things like your data source being in a DATETIME format or your date table does not have enough dates to cover all of the dates in your source.

[carlosflores]

@Anonymous thanks fo your help. 

I tried cicking on "Make this relationship active" but the following message appeared:

"There are ambiguous paths between 'Date table' and 'Source data Table' and 'Another table linked to 'Source data Table'. 

So I deleted the relationship between my source that and that other table. When I did that, everthing worked fine! Thanks again