Calendar Table not linked???

[caballaire]

I set up a calendar table in Power Query using "only create a connection" and I added it to the data model.

I set up the relationships with the fact table and they are marked active.

HOWEVER--the slicer is not working. It only recognizes 36 rows of data and the rest come back (blank)





I noticed the fields show as a long date including time of day. I set each field to show short date but still it is not sorting on all the rows of data. also, note how in the relationship screen the date is the long format.

What am I missing????

 

[Chihiro]

Here's what I would do.

Load both table as connection only in PowerQuery.

In both query, change format of the date column from "Date/Time" to "Date" and merge table using that column. Load resulting query into Data Model and build your pivot from there.